I need to clone a MySQL database from Binary Logs that were obtained from a tape backup. I've always backed-up mysql using mysqldump so I've never had to deal with binary logs (aside from replication) and I'm not sure if I'm approaching this problem correctly.
I need to use the bin logs 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 Database in a VM:
# mysqlbinlog mysqlrestore | mysql -u root -p
I've tried backups from various points and they all give me different errors, for example:
mysqlbinlog: unknown variable 'ssl-ca=/etc/mysql/ca-cert.pem'
and...
ERROR: Error in Log_event::read_log_event(): 'Event too small', data_len: 1, event_type: -46
In the past, to restore a backup I've always loaded a file from a mysqldump using:
# mysql -u root -p < from_mysqldump.sql
So before I go digging into these errors I just want to make sure I'm actually doing something that is possible.