ERROR 1598 (HY000): Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB

最新推荐文章于 2024-11-18 01:43:31 发布

转载最新推荐文章于 2024-11-18 01:43:31 发布 · 1.5k 阅读

文章标签：

本文介绍了解决MySQL数据库导入数据时遇到的错误1598（Binary logging not possible）。该错误与二进制日志选项有关，通常发生在需要复制数据的情况下。文章提供了两种解决方案：一是更改binlog模式为ROW或MIXED；二是如果不需要复制功能，则可以关闭二进制日志。

部署运行你感兴趣的模型镜像

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';

mysql> COMMIT;

If you are not planning to use your MySQL server for the replication consider turning the binary logging off by removing the option --log-bin from the command options for the mysqldutility starting the MySQL server.

原文链接：http://wiki.ispirer.com/sqlways/troubleshooting-guide/mysql/import/binlog_mode_statement

您可能感兴趣的与本文相关的镜像