Magento catalog_product_relation MySQL Error
On transferring a Magento website Database running on MySQL 5.7.34 to MariaDB 10.2.39, I get the following error
|
1 2 3 |
[root@server52 etc]# mysql buildingplans_m1 < db.sql ERROR 1005 (HY000) at line 4080: Can't create table `buildingplans_m1`.`catalog_product_relation` (errno: 140 "Wrong create options") [root@server52 etc]# |
SQL Strict mode was already off on this MySQL server.
|
1 2 3 4 5 6 7 8 9 |
MariaDB [(none)]> select @@sql_mode; +------------+ | @@sql_mode | +------------+ | | +------------+ 1 row in set (0.00 sec) MariaDB [(none)]> |
To fix the problem, edited the db.sql file, added
|
1 |
set innodb_strict_mode = off; |
at the top of the file. After this change, the restore worked without any error.
See Magento