On Tue, Jul 14, 2009 at 2:14 AM, Marcus Bointon<mar...@synchromedia.co.uk> wrote: > You should take a look at Percona's xtrabackup utility to do this. It takes > a clean snapshot of an innodb database that can be restored on a target > machine in a few minutes, though it does crash recovery at backup time which > can take a while.
Most likely the op only tried to copy the ibdata file(s) and not the iblog files. A big honking waving hand over here saying YES, use xtrabackup. It will be a pretty quick recovery process since the db was shut down cleanly. Note that it will restore ALL tables' data, not just the ibdata and iblog files. Just make sure that your innodb settings in my.cnf match. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org