We have been testing Xtrabackup and we are having problems in restoring a backup done on one server to another.
What did work was this: we did a backup on a Linux server with MySQL 5.5 (using the Xtrabackup 1.5 beta) and we then restored it on the same server - worked fine.
Then we did a backup on a server with MySQL 5.0 using Xtrabackup 1.4, and we tried to restore the backup on another server and database, still using MySQL 5.0 and with the same data path (var/lib/mysql) - but we get a non working copy. The database tables are listed (with “show tables”), but if you try to select anything actually the table does not result existing.
In the err log we get:
“Cannot find or open table mydatabase/olpl_wkl_sched_days from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine