Greetings FWLUG, I was curious if anyone had any experience cloning a MySQL database from Binary Logs? I've always backed up mysql using mysqldump so I've never had to deal with binary logs much aside from replication.
Anyways, I've got some binary logs from a tape backup and I need to use them to create a copy of the database so I can do some manual auditing and compare database integrity from a backup several weeks ago with the current database. I put my bin logs in a tmp directory, concatenated them into the 'mysqlrestore' file, then tried to load them into a fresh DB on in a VM. # mysqlbinlog mysqlrestore | mysql -u root -p I've tried backups from various points and they all give me different errors. Is what I'm trying to accomplish possible? Some errors from various backup points: mysqlbinlog: unknown variable 'ssl-ca=/etc/mysql/ca-cert.pem' ERROR: Error in Log_event::read_log_event(): 'Event too small', data_len: 1, event_type: -46 For backups I've always loaded a file from a mysql dump like: # mysql -u root -p < from_mysqldump.sql So before I go digging into these errors I just want to make sure I'm doing something that is actually possible. Thanks! _______________________________________________ Fwlug mailing list [email protected] http://mail.fortwaynelug.org/mailman/listinfo/fwlug_fortwaynelug.org This is a public list and all posts are archived publicly. Please keep this in mind before posting.
