`
收藏列表
标题 标签 来源
导出MySQL LogBin日志内容 mysql 
#!/bin/bash

BINLOGDIR=`cat /etc/mysql/my.cnf | grep datadir | awk '{print $3}'`
MYSQL="/usr/bin/mysql -A -e"
BINLOGPREFIX=`${MYSQL} "show master status" | awk 'NR==2{print $1}' | awk -F. '{print $1}'`
DATABASE="selfnovel"
cd "${BINLOGDIR}"

BINLOGS="mysqld-bin.000044 mysqld-bin.000045 mysqld-bin.000046 mysqld-bin.000047"
for i in ${BINLOGS}
do
  ${MYSQL} "show binlog events in '${i}'" | grep "${DATABASE}" | grep "Query" | awk -F'use `${DATABASE}`; ' '{print $2}'mysqlbinlog.$i.sql
done
Global site tag (gtag.js) - Google Analytics