DBD::mysql::db do failed: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. [for Statement "DELETE FROM `database_name`.`table_name` LIMIT 0"] at ./bin/pt-table-sync line 5577.
For information this is the error returned when delete permissions is checked,
eval { $dbh->do($sql); };
my $can_delete = $EVAL_ERROR ? 0 : 1;
this returns:
DBD::mysql::db do failed: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. [for Statement "DELETE FROM `database_ name`.` table_name` LIMIT 0"] at ./bin/pt-table-sync line 5577.