Migration of wordpress database from mariadb 10.0.20 to 5.5.50
I have been struggling with this one and cannot find an answer. I am not an expert with databases and had an issue that is a pain.
I am attempting to migrate a wordpress database to a different server host. The current MariaDB version is 10.0.20 and the new one is 5.5.50
I used phpmyadmin to dump the database I imported it to the new host and got this issue.
I resolved by following the sollution to use MYSQL40
Then trying again I got an issue with TYPE=INNODB.
Found the solution and changed TYPE=INNODB to ENGINE=InnoDB in the dump.
Now I get this error and I have no idea how to resolve and found nothing useful
Warning in ./libraries/dbi/DBIMysqli.php#252 Error while sending QUERY packet. PID=2622 Backtrace ./libraries/dbi/DBIMysqli.php#252: mysqli_query( object, string 'SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS';', integer 0, ) ./libraries/DatabaseInterface.php#240: PMAlibrariesdbiDBIMysqli->realQuery( string 'SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS';', object, integer 1, ) ./libraries/DatabaseInterface.php#1586: PMAlibrariesDatabaseInterface->tryQuery( string 'SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS';', object, integer 1, boolean false, ) ./libraries/DatabaseInterface.php#1380: PMAlibrariesDatabaseInterface->fetchValue( string 'SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS';', integer 0, integer 1, object, ) ./libraries/DatabaseInterface.php#1400: PMAlibrariesDatabaseInterface->getVariable( string 'FOREIGN_KEY_CHECKS', integer 1, object, ) ./libraries/Util.php#3328: PMAlibrariesDatabaseInterface->setVariable( string 'FOREIGN_KEY_CHECKS', string 'ON', ) ./import.php#636: PMAlibrariesUtil::handleDisableFKCheckCleanup(boolean true)
Hopefully someone might have a suggestion. Thank you