Home  Home  Home  Kontakt  Kontakt  Kontakt  Inhalt  Inhalt  Inhalt  Blog  Blog  Blog  FAQ  FAQ  FAQ

Binary Logs

SHOW BINARY LOGS;
PURGE BINARY LOGS TO 'mysql-bin.000nnn';
PURGE BINARY LOGS BEFORE '2015-04-10 22:46:26';
SET GLOBAL expire_logs_days=5;
FLUSH LOGS;
SHOW BINLOG EVENTS LIMIT 0,30;
SHOW BINLOG EVENTS IN 'mysql-bin.000nn' LIMIT 10;
mysqlbinlog /var/lib/mysql/mysqld-relay-bin.000140 | tail -20
cd $HOME/tmp
for file in /var/log/mysql/mysql-bin.00nnn*; do
    echo "mysqlbinlog $file > " $(basename $file).txt;
done
cd $HOME/tmp
for file in /var/lib/mysql/mysqld-relay-bin.00nnn*; do
    echo "mysqlbinlog $file > " $(basename $file).txt;
done

Ähnliche Seiten