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
[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.
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
set innodb_strict_mode = off;
at the top of the file. After this change, the restore worked without any error.
See Magento