See MySQL 5.5 Last change: 03/22/2013 8 MySQL Database System MYSQLBINLOG(1) Section 7.3, "Example Backup and Recovery Strategy". o --stop-datetime=datetime Stop reading the binary log at the first event having a timestamp equal to or later than the datetime argument. This option is ...
(22007): Incorrect date value: '0000-00-00' for column 'a' at row 1 This problem does not occur when binlog is disabled or binlog_row_image=minimal.How to repeat:mysql> SET sql_mode=''; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> CREATE TABLE default_date(a DATE ...
Hi, Thank you for your bug report. This seems like a duplicate of the bug:https://bugs.mysql.com/bug.php?id=91941However, since this report is much more clear and is a bit different, I will set it to "Verified" and not to "Duplicate". ...