Am 26.02.2014 15:40, schrieb AskMonty KB: > A new question has been asked in "MariaDB community" by hannasles: > -------------------------------- > 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
no - you are moving to MySQL not MyISAM MyISAM is a engine of both > 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; use ENGINE=MyISAM because Aria is a MariaDB specific engine and remove PAGE_CHECKSUM=1 at all if you are to sure that you can stay forever on a modern hosting with MariaDB you should always avoid specific features and engines from th every first start because you break interoperability otherwise
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
