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 -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
