Maria DB - changing hosting with a different DB
Hi Guys! I am moving my web-site from one hosting to another. The DB on the first hosting is MariaDB, DB on the hosting I am moving to is MyIsam.
When importing the DB, I am getting this message: ERROR 1064 (42000) at line 19: 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 6
Line 19 runs: CREATE TABLE `wp_blc_filters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1;
As I am not good at all with DB and my hosting supports can not answer my enquiries, I have to open this question here.
I will really appreciate that if you could help me with this!
Answer Answered by Federico Razzoli in this comment.
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/
