Ispirer Home Page
Ispirer SQLWays Product Page - Migration to MySQL
Request SQLWays
Symptoms
On the import of objects to the MySQL database the following message may arise: “ERROR 1598 (HY000) at line 25: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'”.
Cause
The error arises when you try to load the data to the MySQL database. The error arises only if the binary logging option, which is required for the replication, is turned on for the MySQL server.
Solutions
There are several solutions for the issue:
mysql> SET GLOBAL binlog_format = 'ROW';
Ispirer Home Page
Ispirer SQLWays Product Page - Migration to MySQL
Request SQLWays
© 1999-2021, Ispirer Systems Ltd. All Rights Reserved. Privacy Statement |