I found the ibdata and logfiles, but outside from my database dir. so basically I need copy everything in /var/lib/mysql/* ?
2011/5/27 <a.sm...@ukgrid.net>: > > Quoting Yoshio <geanyos...@gmail.com>: > >> I can use mysqldump but its take many hours to complete a restore. I >> can stop the server, so i'm think in a physical copy of the database. >> But I have not found the innodb files. Where are that files? >> > > InnoDB is a bit tricky, without going into details (I couldn't reliably > describe them anyway) doing an online backup by locking tables isn't > sufficient for InnoDB. The database must be cleanly shutdown before you take > your copy. Another thing I read is that you must restore all InnoDB > databases and tables from a cold backup, you cannot copy only those you > want. The data files should be under your data dir, normally ibdata1 and > some ib_logfile files, plus any related subdirectories. You should be able > to safely exclude any MyIsam only databases as per usual, > > cheers Andy. > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org