Background:
Execute the following statement to report an error:
mysqldump.exe -uroot -p --master-data=2 --single-transaction --routines --triggers --events mc_orderdb > aa.sql
Tried Methods:
1. Modify the configuration file and add the following configuration
#Enable binary logging
log-bin=mysql-bin
Then restart the service
It doesn’t work
2. Delete — master data = 2 parameter
Export succeeded
Read More:
- [Solved] Mysql Build Error: [ERROR] Slave I/O for channel ‘‘: error connecting to master
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- ERROR 3021 (HY000): Unknown error 3021 [How to Solve]
- How to Solve mysql [Err] 1067-Invalid default value for
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
- Solve ERROR 1231 (42000): Variable’time_zone’ can’t
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- MAC MYSQL Start Error: The server quit without updating PID
- [Solved] mysqldump Command Error: Got error: 2002: “Can‘t connect to server on ‘127.0.0.1‘ (36)“ when trying to connect
- [Solved] Starting MySQL… ERROR The server quit without updating PID file
- How to Solve Mysql8 load data error
- ERROR: mysqld failed while attempting to check config [How to Solve]
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- [error][/usr/share/perl5/vendor_perl/MHA/SSHCheck.pm, ln63] Permission denied (publickey,gssapi-ke
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- MySql Warning: The server quit without updating PID file error
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- Mysql ERROR 1067: Invalid default value for ‘date’ [How to Solve]