MySQL Forums
Forum List  »  InnoDB

Re: InnoDB to MYISAM back to InnoDB
Posted by: Per Hallström
Date: March 11, 2008 03:05PM

If I interpret your situation correctly, you have accidently "downgraded" from InnoDB to MYISAM after which new/additional data has been inserted in the MYISAM tables. You seem to have a backup of the old data and tables (InnoDB tables) still around, which gives you another option:

1. Create a "structure dump" of your old InnoDB tables (use "--no-data" when dumping with mysqldump). This will give you a empty InnoDB tables with foreign keys etc.

2. Dump only data from your MYISAM tables (use "--no-create-db --no-create-info" when dumping data). This will give you only data but not table definitions etc. If you data does not violate any constraint in the InnoDB tables, it should insert fine.

If possible, you should use a second/third database instance for this as it might fail somewhere in the middle if a foreign key constraint fails, etc. Additionally, this approach assumes that you have not changed the tables in any way after they were accidently changed to MYISAM.

Please let me know if this would work for you!

Options: ReplyQuote


Subject
Views
Written By
Posted
2237
March 11, 2008 02:02PM
Re: InnoDB to MYISAM back to InnoDB
1482
March 11, 2008 03:05PM
1409
March 11, 2008 03:10PM


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.