Backup procedure
All, I'm looking for opinions/suggestions on a backup procedure I plan on implementing. All databases (DBXX) will be MySQL ver 4.0 All our applications work with DB01. DB01 replicates to DB02. Once a day I will Stop the slave on DB02, lock the tables, flush the logs and perform a mysqldump of the database. I will then copy the existing bin.log files and config filesls to a backup directory and then backup the db dump and bin.logs to an external backup device. A) this seems like the most non-intrusive way to get a clean backup of the database, is it? B) I'm not sure how I'm going to automate the unlocking of the tables and the restart of the slave only AFTER the dump is done. Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Backup procedure
All, I'm looking for opinions/suggestions on a backup procedure I plan on implementing. All databases (DBXX) will be MySQL ver 4.0 All our applications work with DB01. DB01 replicates to DB02. Once a day I will Stop the slave on DB02, lock the tables, flush the logs and perform a mysqldump of the database. I will then copy the existing bin.log files and config filesls to a backup directory and then backup the db dump and bin.logs to an external backup device. A) this seems like the most non-intrusive way to get a clean backup of the database, is it? B) I'm not sure how I'm going to automate the unlocking of the tables and the restart of the slave only AFTER the dump is done. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]