ERROR 1598 (HY000): Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB
来源:互联网 发布:调色板软件 编辑:程序博客网 时间:2024/06/16 05:43
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
0 0
- ERROR 1598 (HY000): Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB
- Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB
- MySql之错误异常--Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is no
- MYSQL:Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
- InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMIT
- Jira的 Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'错误的解决
- Jira的 Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'错误的解决 原创 2
- Redo Logging in InnoDB
- schemaValidationMessages":[{"level":"error","message":"Can't read from file /swagger.json"}]
- sql error:Last_Error: Relay log read failure: Could not parse relay log event entry. The possible re
- ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in
- ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in
- CO-doc. number assignment not possible for bus.trans. COIN in CO area 1800 Message no. KC101
- [Samba] "Not Enough '/' Characters In Service" Error Message
- “Parser Error Message: Could not load type” in Global.asax
- "Debugging not possible in single session mode"
- Getting this error message: dbModel read resource does not implement Zend_Db_Adapter_Abstract
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- 为什么你应该(从现在开始就)写博客--把这篇文章作为自己开始博客生涯的节点吧
- 最大流的增广路算法比较
- MFC中对,对话框进行分离使用解决方法
- quick-cocos2d-x 加密
- 第十周项目四:大奖赛记分
- ERROR 1598 (HY000): Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB
- 安卓安全小分队发现Android新漏洞
- 动态标绘演示系统1.4.3(for ArcGIS Flex)
- |在编辑框中显示数据|
- 注册本地通知【闹钟,备忘录】
- ansi 控制码表及颜色代码
- uva 562Uva 562 Dividing coins
- 系统打开DEMO
- Mac上编译安装nginx报错