Not the answer you need?
Register and ask your own question!

innobackupex --copy-dir does not restore InnoDB tables correctly.

ayushsharmaayushsharma EntrantCurrent User Role Beginner
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?


  • weeblrweeblr Entrant Inactive User Role Beginner

    Exact same problem here (though using --copy-back). Did you found a solution for this?

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.