MySql备份

1. add a my.ini file in the installation folder(windos), the content is as below

log-bin="D:/mysql-5.6.21-winx64/data/binlog/bin-log"
binlog-format=MIXED

2. the above content has enabled the binary log, it also set the log format

3. stop the mysql with below command

bin\mysqladmin.ext -u root -p shutdown

4. launch the mysql

bin\mysqld.exe

5. check mysql binary log status with mysql client

bin\mysql.exe

show master logs

show variables like '%binlog%'

6. export mysql

bin\mysqldump -u root -p --single-transaction --flush-logs --all-database --master-data=2 > mysql_full_duml.sql

7. check mysql version

select version();