On 26 Jun 2003 at 12:24, SAQIB wrote: > > mysqlhotcopy does your locking for you. > > So running > ./mysqlhostcopy dbase /path/to/backup/dir > > is perfectly safe while database operations (selct, insert, update > etc) are being performed?
Yes, but the inserts and updates will all be blocked until after the copying is done. If your database is big enough and active enough that locking it during the copying time is unacceptable, consider setting up a replication server and backing that up instead. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
