Re: Backup/Restore failing between 2 machines
Posted by:
Rick James
Date: February 24, 2012 12:07AM
> we recently switched to INNODB format
Elaborate on what you did to switch.
Do NOT change the tables in the `mysql` database to InnoDB. Nor those in `information_schema`.
"default-storage-engine = INNODB " applies only to new tables, not to those reloaded from a dump.
When you "restored", do you start with no databases?
Where did the restored `mysql` come from?
"innodb_file_per_table" applies only to new tables. Were all the tables on the original machine in their own .ibd files? Or were the built before setting that flag, hence living in ibdata1?
Subject
Views
Written By
Posted
2803
February 22, 2012 03:16PM
1587
February 22, 2012 03:20PM
Re: Backup/Restore failing between 2 machines
1293
February 24, 2012 12:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.