Migration of wordpress database from mariadb 10.0.20 to 5.5.50

Question

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.
https://stackoverflow.com/questions/21190523/phpmysql-error-1273-1273-unknown-collation-utf8mb4-general-ci

I resolved by following the sollution to use MYSQL40

Then trying again I got an issue with TYPE=INNODB.

https://stackoverflow.com/questions/9620439/syntax-error-when-running-a-mysql-create-table-statement

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

0
dgibbs 5 years 2016-09-17T04:23:38-05:00 0 Answers 75 views 0

Leave an answer

Browse
Browse