Mysql migration from 6 to 5

Now that mysql 6 alpha was announced at it’s end and has not been updated since 2009, I am trying to move a client’s installation to the latest source distro on a brand new server.

Trying to migrate a mysql database from
6.0.11-alpha-community-log MySQL Community Server

to Server version: 5.0.95 Source distribution

getting
ERROR 1286 (42000) at line 37753: Unknown table engine ‘MARIA’

Solution? edit the dump file replacing MARIA with MyISAM

ERROR 1064 (42000) at line 37753: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘PAGE_CHECKSUM=1’ at line 13

Removed the part that says “PAGE_CHECKSUM=1”
Success!

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *