Solution: #>vi /etc/my.cnf.d/server.cnf
[mysqld]
innodb_strict_mode=0
[galera]
default_storage_engine=InnoDB
[mysqld]
innodb_strict_mode=0
[galera]
default_storage_engine=InnoDB
#>service mysql restart
Import again
Similar Posts:
- How to Solve Mysql Error 1206: The total number of locks exceeds the lock table size
- MYSQL Insert: SQLSTATE[HY000]: General error: 1364 Field ‘xxxxx’ doesn’t have a default value
- ‘InnoDB’ init function returned error.[mysql5.6]
- [Solved] MYSQL Command gruop by Error: this is incompatible with sql_mode=only_full_group_by
- [Solved] MYSQL8 group by Error: Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY
- incorrect integer value for column [How to Solve]
- Unknown system variable ‘storage_engine’
- [Solution] mysql Unknown storage engine ‘InnoDB’
- Laravel Syntax error or access violation: 1055 ‘***’ isn’t in GROUP BY