|List:||General Discussion||« Previous MessageNext Message »|
|From:||Russell Uman||Date:||October 8 2002 10:44pm|
|Subject:||RESET MASTER during daily backups|
|View as plain text|
howdy. we use the binary log as a crash recovery tool. therefore, once we have backed up the db (we use the excellent mysql_backup for this) we can happily discard yesterday's binlog. the only correct way i've found to get rid of old binlogs in to issue RESET MASTER, and i figure i should do this at the same time that the logs get flushed. however, neither mysqldump nor mysqladmin have a RESET MASTER option. has anyone found a good way to do this?
|• RESET MASTER during daily backups||Russell Uman||9 Oct|
|• re: RESET MASTER during daily backups||Victoria Reznichenko||9 Oct|