ERROR 1666 (HY000): Cannot execute statement: impossible to write to binary log since statement is i...
576 ワード
centos7.5 binlogデータのリカバリに失敗しました
質問:
理由:
解決方法:
転載先:https://www.cnblogs.com/lvhanzhi/p/10615514.html
質問:
mysql> \. /tmp/inc.sql
ERROR 1050 (42S01): Table 'new_1' already exists
ERROR 1666 (HY000): Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.理由:
binlog statement , row binlog解決方法:
binlog row
[root@db01-51 ~]# vim /data/3307/my.cnf
[mysqld]
log-bin=mysql-bin
binlog_format=row
, 転載先:https://www.cnblogs.com/lvhanzhi/p/10615514.html