Backup procedure

2003-09-02 Thread Jeff McKeon
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 mysqldu

Backup procedure

2003-08-28 Thread Jeff McKeon
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 mysqldu