Timeline for importing myisam 5.0 database into a 5.5 innodb server
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 16, 2012 at 19:18 | comment | added | names_are_easy | This worked. If you don't have a lot of databases (and NOT the mysql database) it is an easy way to switch to INNODB and 5.5. The one trick is that when you create the dumpfile, use mysqldump --order-by-primary. | |
| Jan 30, 2012 at 15:18 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 422 characters in body |
| Jan 30, 2012 at 13:51 | vote | accept | names_are_easy | ||
| Jan 30, 2012 at 13:51 | comment | added | names_are_easy | I will only be importing selected databases and the mysql database will definitely not be one of them. Looks like this will work. | |
| Jan 27, 2012 at 23:35 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 33 characters in body |
| Jan 27, 2012 at 22:33 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 33 characters in body |
| Jan 27, 2012 at 22:25 | comment | added | names_are_easy | I should have put this into the question: I edited the dump file from the 5.0 database from ENGINE=MyISAM to ENGINE=InnoDB. I am being paranoid here, just want to make sure that jumping versions won't doing anything crazy. | |
| Jan 27, 2012 at 21:03 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |