"Gerald L. Clark" <[EMAIL PROTECTED]> wrote: Mathieu Bruneau wrote: > murthy gandikota a écrit : > >>Hi >> I did a hot backup a while ago. When I had to restore from backup there were >> several error messages. So I ran mysqlcheck for every table with >> --auto-repair option. Is this the best way? >> >> Thanks >> Murthy >> >> >>--------------------------------- >>Ahhh...imagining that irresistible "new car" smell? >> Check outnew cars at Yahoo! Autos. > > > Yes you should shutdown the database before doing a mysqlhotcopy. > However you could use the "flush tables with read lock" so that your > tables are consistent (and will still allow for select to go through the db) > > Best luck > > mysqlhotcopy does not require a database shutdown. If it did, it would not be a hot copy.
-- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] I am sorry for not being clear. I make a tar ball of all the files. I've not used mysqlhotcopy. I hope it creates a backup on the NFS mount. Thanks --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos.