Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Enable binlog (my.cnf) -- log_bin = /var/log/mysql/mysql-bin.log -- server_id = 1 -- binlog_format = ROW (recommended: row-based logging) -- Show binlog status SHOW MASTER STATUS\G SHOW BINARY LOGS; -- View binlog events SHOW BINLOG EVENTS IN "mysql-bin.000001" LIMIT 20; -- mysqlbinlog (command line) -- mysqlbinlog mysql-bin.000001 | mysql -u root
Result
Open