MySQL Invalid default value for XXX datetime based field
Working servers suddenly start giving the error below when restoring a MySQL database that contains datetime fields with 0000-00-00 defaults: user@server:/tmp# mysql -uuser -ppassword database_name