Incorrect datetime value: '0000-00-00 00:00:00'. How to fix?

Question

MySQL

I am deploying a backup of the 1C-Bitrix site and when I start restoring the database, I get an error.

MySQL query error!
Incorrect datetime value: '0000-00-00 00:00:00' for column 'TIMESTAMP_X' at row 1

What could be the problem? Can it be fixed?

Answer 1

Found the reason. Solution: run query:
SET GLOBAL sql_mode='';

Answer 2

SET SQL_MODE='ALLOW_INVALID_DATES'

Answer 3

mysqldump -u root -p --default-character-set=utf8 --result-file=backup.sql newdatabase