mysqldump: Error: Binlogging on server not active [How to Solve]


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

Then restart the service

It doesn’t work

2. Delete — master data = 2 parameter

Export succeeded

Read More: