Mysql import error: Invalid Datetime default value 0000-00-00 00:00:00

Mr Tan

• 1 min read
Mysql import error: Invalid Datetime default value 0000-00-00 00:00:00

Use the following import command to resolve the problem:

mysql -uroot -p database_name --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;SET SQL_MODE='ALLOW_INVALID_DATES';" < database_dump.sql

Sign up for more like this.

Enter your email
Subscribe