After using innobackupex --copy-dir and then correcting permissions for /var/lib/mysql, I restart the MySQL server. I can see the MyISAM and Memory tables and their data has been restored properly, but the data for InnoDB tables is incorrect. MyISAM tables show up in SHOW TABLES and SHOW TABLE STATUS, but InnoDB tables only show up in SHOW TABLES. When I try to print data of an InnoDB table, it says “Table does not exist”. What do I do?
Hi
Exact same problem here (though using --copy-back). Did you found a solution for this?
Thanks