Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Enable binary logging (in my.cnf) -- [mysqld] -- log_bin = /var/log/mysql/mysql-bin.log -- server-id = 1 -- List binary log files SHOW BINARY LOGS; -- Replay binary logs up to a specific time -- mysqlbinlog --stop-datetime="2025-05-02 14:30:00" \ -- /var/log/mysql/mysql-bin.000042 \ -- | mysql -u root -p myapp_db -- Show binary log events SHOW BINLOG EVENTS IN 'mysql-bin.000042' LIMIT 20;
Result
Open