mysqlバイナリログ設定

http://www.cnblogs.com/wangkongming/p/3684950.html

-- mysql    C:\ProgramData\MySQL\MySQL Server 5.7\my.ini
# Binary Logging.
 log-bin=d:/mysql/log/
--        
show global variables like "%log_bin%";
--                   
show binary logs;
--        
show binlog events in '.000002';
--       
show master status;

   
  SQL
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqlbinlog d:/mysql/log/.000002 > d:/a.sql

C:\Program Files\MySQL\MySQL Server 5.7\bin> mysqlbinlog --base64-output=decode-rows -v -d mis d:/mysql/log/.000002> d:/m.sql