On 12/29/16 13:25, asari wrote: > It looks like you are using relatively new MySQL server which has stricter > policies. > > http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-changes > > My workaround was to dump, sed and restore from backup, i.e.: > > $ sed -e 's/0000-00-00 00:00:00/1970-01-01 00:00:00/g' \ > ... < /tmp/var/lib/bacula/bacula.sql \ > ... | mysql -ubacula -p bacula
Well, you COULD do it that way. Or you could temporarily disable no-zero-date and no-zero-in-date in SQL_MODE, do a couple of UPDATE operations to change all 0000-00-00 00:00:00 dates to 1970-01-01 00:00:00, and restore the original SQL_MODE. -- Phil Stracchino Babylon Communications [email protected] [email protected] Landline: 603.293.8485 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
