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.<\/p>\n
Trying to migrate a mysql database from
\n6.0.11-alpha-community-log MySQL Community Server<\/p>\n
to Server version: 5.0.95 Source distribution<\/p>\n
getting
\nERROR 1286 (42000) at line 37753: Unknown table engine ‘MARIA’<\/p>\n
Solution? edit the dump file replacing MARIA with MyISAM<\/p>\n
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<\/p>\n
Removed the part that says “PAGE_CHECKSUM=1”
\nSuccess!<\/p>\n","protected":false},"excerpt":{"rendered":"
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 … Continue reading