From: Todd Lyons Date: September 10 2009 10:43pm Subject: Re: DB/table problem List-Archive: http://lists.mysql.com/mysql/218692 Message-Id: <48b1344b0909101543n5870350et47c709431a7abc15@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote: > When using innodb, your data is stored in the data/ibdata* files. =A0Copy= ing the database directory is not a valid backup. > > In the future, I would suggest using mysqldump. =A0However if you want to= make a file-system copy backup with innodb you need to 1. Shutdown the ser= ver 2. Copy *everything* in the data directory 3. Store a copy of your my.i= ni 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. --=20 Regards... Todd