I'm running mysql version 4.1.20, with all tables in InnoDB. I'm having
problems getting consistent backups with mysqlbindump and binary logs.
I'm running mysqlbindump with the following options:
"--quick --single-transaction --flush-logs --add-drop-table
I run mysqldump separately for each database, and then flush logs one
last time. The databases need to be backed up separately because I may
occasionally need to restore one database at a time.
I am trying to use these backups to build a slave.
So what I do is take all these dumps and load them into the database
and then run the binlog that ...