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!