mysqlbinlog

Utility for processing MySQL binary log files. More information: <https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html>.

Install

All systems
curl cmd.cat/mysqlbinlog.sh
Debian Debian
apt-get install mariadb-server-10.3
Ubuntu
apt-get install percona-xtradb-cluster-server-5.5
Alpine
apk add mysql
Arch Arch Linux
pacman -S percona-server-clients
image/svg+xml Kali Linux
apt-get install mariadb-server-10.1
CentOS
yum install mysql
Fedora
dnf install mariadb-3
Windows (WSL2)
sudo apt-get update sudo apt-get install percona-xtradb-cluster-server-5.5
OS X
brew install mysql
Raspbian
apt-get install mariadb-server-5.5
Dockerfile
dockerfile.run/mysqlbinlog
Docker
docker run cmd.cat/mysqlbinlog mysqlbinlog powered by Commando

Utility for processing MySQL binary log files. More information: <https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html>.

  • Show events from a specific binary log file:
    mysqlbinlog path/to/binlog
  • Show entries from a binary log for a specific database:
    mysqlbinlog --database database_name path/to/binlog
  • Show events from a binary log between specific dates:
    mysqlbinlog --start-datetime='2022-01-01 01:00:00' --stop-datetime='2022-02-01 01:00:00' path/to/binlog
  • Show events from a binary log between specific positions:
    mysqlbinlog --start-position=100 --stop-position=200 path/to/binlog
  • Show binary log from a MySQL server on the given host:
    mysqlbinlog --host=hostname path/to/binlog

© tl;dr; authors and contributors