Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:troubleshooting-guide:mysql:import:binlog_mode_statement [October 07, 2009, 10:20:52 AM]
leonov
sqlways:troubleshooting-guide:mysql:import:binlog_mode_statement [May 07, 2018, 03:15:34 PM] (current)
Line 1: Line 1:
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/mysql-migration|Ispirer SQLWays Product Page - Migration to MySQL]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
 +
 +====== ERROR 1598 (HY000): Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB is not Safe for Binlog Mode STATEMENT ======
 +
 +**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:
 +
 +  * You need to change the binlog mode to either **ROW** or **MIXED** in order to run the load of the data into the database
 +
 +   mysql> SET GLOBAL binlog_format = 'ROW';
 +
 +  * If you are not planning to use your MySQL server for the replication consider turning the binary logging off by removing the option <html><i>--log-bin</i></html> from the command options for the //mysqld// utility starting the MySQL server.
 +
 +
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/mysql-migration|Ispirer SQLWays Product Page - Migration to MySQL]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
  
sqlways/troubleshooting-guide/mysql/import/binlog_mode_statement.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement