Window 下mysql binlog開啟及查看

標籤：mysql   binlog   

查看是否開啟了binlog:

win+r => cmd => 串連mysql=>show variables like ‘log_%‘;   

mysql> show variables like 'log_%';+---------------------------------+-------------+| Variable_name                   | Value       |+---------------------------------+-------------+| log_bin                         | ON          || log_bin_trust_function_creators | OFF         || log_error                       | .\mysql.err || log_queries_not_using_indexes   | OFF         || log_slave_updates               | OFF         || log_slow_queries                | ON          || log_warnings                    | 1           |+---------------------------------+-------------+

沒有開啟log_bin的值是OFF,開啟之後是ON

開啟binlog:

修改mysql設定檔 my.ini

添加配置：log-bin=log-bin=D:\AppServ/MySQL/log/mysql-bin.log   測試發現必須給全路徑(名字隨意給)

重啟mysql 會在log目錄下新增兩個檔案mysql-bin.000001與mysql-bin.index

查看binlog:

win+r => cmd => 串連mysql=> show binary logs; =>可以查看自己binlog的名稱

win+r => cmd => 串連mysql=> show binlog events; =>可以查看已產生的binlog

匯出成文字檔：

D:\AppServ\MySQL\bin>mysqlbinlog >d:/test.txt

確保在bin目錄下有mysqlbinlog.exe 沒有的話搜尋下載

Window 下mysql binlog開啟及查看