I'd instead setup a 2nd backup server that's a slave to the master, replicates all the time, keeps in sync.
At X time, stop replication/mysql, backup data to tape .. restart mysql and it will catch up/re sync back to master.. On Thu, 26 Jun 2003, 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? > > --- > Saqib Ali > http://www.xml-dev.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
