MariaDB DEFAULT NULL ERROR 1064 (42000)

When trying to restore a MySQL databse bakcup taken on MySQL 5.7 server to MairaDB 10.1 server i get following error.

Source server

Destination server

I opend the SQL file in editor and checked line 287, i run the SQL in mysql, that resulted in error

I run the command on a MariaDB 10.2 server and it worked.

To fix the problem, upgrade MariaDB to version 10.2 or above. In this case, i went with MariaDB 10.04 and it worked fine.

Add a Comment

Your email address will not be published. Required fields are marked *