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] mysqldump Command Error: Got error: 2002: “Can‘t connect to server on ‘127.0.0.1‘ (36)“ when trying to connect
- Mysqldump: Got error: 1045: Access denied for user ‘root‘@‘localhost‘
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- [Solved] mysqldump: Got error: 1556: “You can‘t use locks with log tables.“ when using LOCK TABLES
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
- [Solved] MySQL Error: Client does not support authentication protocol requested by server
- [Solved] Error: ER_HOST_NOT_PRIVILEGED: Host ‘x.x.x.x‘ is not allowed to connect to this MySQL server
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- Navicat connected to Mysql error: Client does not support authentication protocol requested by server;
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
- [Solved] Starting MySQL… ERROR The server quit without updating PID file
- MySQL server has gone away Error [How to Solve]
- MAC MYSQL Start Error: The server quit without updating PID
- MySql Warning: The server quit without updating PID file error
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’