A Critical Warning If You Are Using InnoDB Hot Backup
Posted by Sheeri Cabral on Feb 12, 2009
If you are using InnoDB Hot Backup and a recent version of mysqld (at least 5.0.67 or higher, including 5.1.30, though it may be later versions), your backup will run fine and output OK! at the end, as it should.
Except for one thing.
The binary log file and position do not appear in their rightful place. Here’s a snippet of the output from the backup:
innobackup: MySQL binlog position: filename 'Warning', position (Code 1287): 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead 090210 03:55:04 innobackup: innobackup completed OK!
That’s pretty misleading — looks like the backup completed OK, but it did not show us the binary log position. What about the ibbackup_binlog_info file?
[mysql@db3:~] more ibbackup_binlog_info Warning (Code 1287): 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead [mysql@db3:~]
Yikes! What happened to the binary log position and file information?
Have no fear, it’s actually in another file.
