Comments - Maria DB - changing hosting with a different DB

10 years, 1 month ago Federico Razzoli

You are either moving from MariaDB to MySQL, or from Aria to MyISAM. Aria was formerly called Maria, which probably still confuses some people. Your example makes me think that the second hypotesys is correct.

If you are moving to MyISAM, you should change ENGINE=Aria to ENGINE=MyISAM, and remove PAGE_CHECKSUM, because it is an Aria-specific clause. You can obtain something similar with CHECKSUM=1.

For the exact meaning of these clauses, see https://mariadb.com/kb/en/create-table/

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.