← Back to team overview

maria-discuss team mailing list archive

Re: Copying database files

 

> >> The code doing this stops everything talking to the database (Yes, I
> >> know there could be someone fiddling remotely in a shell, but this is
> >> very unlikely). Even tables which are never written to cause this
> >> error
> >>
> >> So if I'm careful, is there a way to make this work without stopping
> >> the server?
> >
> > I'd expect FLUSH TABLES ... FOR EXPORT to work.
> >
> > What exactly are you getting? Can you perhaps create a test case? Or
> > just report a bug at jira.mariadb.org?
> 

It looks like I need to run aria_chk -z every time before I do the copy. Is that expected?

I guess if something has been "freed" in the table the free block needs to be zero filled, presumably for security reasons. For my application I don't care, so I'm wondering if there is an option to avoid this.

Thanks for your help.

Andy Ling

**********************************************************************
DISCLAIMER:
Privileged and/or Confidential information may be contained in this message. If you are not the addressee of this message, you may not copy, use or deliver this message to anyone. In such event, you should destroy the message and kindly notify the sender by reply e-mail. It is understood that opinions or conclusions that do not relate to the official business of the company are neither given nor endorsed by the company. Thank You.


References