Hi Todd, I didn't mention xtrabackup because I have no experience with it =) I know the other methods work, and honestly, for most mysql users just starting out, it's easier to use mysqldump. It's simple, and it's easy to get help with, and it works across storage engines.
Regards, Gavin Towey -----Original Message----- From: tly...@sitehelp.org [mailto:tly...@sitehelp.org] On Behalf Of Todd Lyons Sent: Thursday, September 10, 2009 3:44 PM To: Gavin Towey Cc: mysql@lists.mysql.com Subject: Re: DB/table problem On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey <gto...@ffn.com> wrote: > When using innodb, your data is stored in the data/ibdata* files. Copying > the database directory is not a valid backup. > > In the future, I would suggest using mysqldump. However if you want to make > a file-system copy backup with innodb you need to 1. Shutdown the server 2. > Copy *everything* in the data directory 3. Store a copy of your my.ini with > the backup as well. 4. Restart mysql Do you exclude xtrabackup as a potential solution because he's using Windows (it doesn't build on Windows) or because you have some issue or problem with xtrabackup? I'm not aware of any show-stopper bugs. I'm just curious, because it works well for us. The backup is online with the only lock held occuring while it's copying over the *.frm and *.MY* files, which is not very much for us. -- Regards... Todd The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
