Menu
When I started up my MySQL server today and try to do some changes using Toad for Mysql, I get this message:
MySQL Database Error
Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
I have no idea what this means. I'm running Mysql on VirtualBox with Ubuntu 11.x.
Has anyone run into this problem before?
292
From MySQL 8.0, binary logging is enabled by default, whether or not you specify the --log-bin option. The exception is if you use mysqld to initialize the data directory manually by invoking it with the --initialize or --initialize-insecure option, when binary logging is disabled by default.
To retrieve a list of all the BinLogs present in your system, make use of the following command: mysql> SHOW BINARY LOGS; This command will display a list of all binary logs present in the system only when the binary log is enabled otherwise, it gives an error.
The MySQL Binary Log origin generates one record for each transaction recorded in the binary logs. The record includes fields and record header attributes that contain the operation type, the change data capture information, and the changed data, as well as information about the primary key when applicable.
Change the default location of the Binary Logs The MySQL binary logs and index files are saved in the C:\ProgramData\MySQL\MySQL Server 8.0 directory. We can change the default location of the binary logs.
According to ERROR 1598 (HY000): Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB is not Safe for Binlog Mode STATEMENT:
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
--log-binfrom the command options for the mysqld utility starting the MySQL server.
70
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
