mysql binlog备份脚本

#!/bin/bash

# 备份目录
backup_dir="/var/backups/mysql"
bin_log_dir="/var/backups/binlog"

# MySQL登录信息
mysql_host="#############"
mysql_user="--------------"
mysql_pwd="************"
PORT=3306
MYSQL=/usr/bin/mysql
MYSQLBINLOG=/usr/bin/mysqlbinlog


BINLOG_FILES=`$MYSQL --host=$mysql_host --port=$PORT --user=$mysql_user --password=$mysql_pwd -e "SHOW BINARY LOGS;" | awk '{print $1}' | grep -v 'Log_name'`

echo $BINLOG_FILES


for BINLOG_FILE in $BINLOG_FILES; do

   # $MYSQLBINLOG --read-from-remote-server --raw --host=$mysql_host --port=$PORT --user=$mysql_user --password=$mysql_pwd  $BINLOG_FILE
    $MYSQLBINLOG --read-from-remote-server --raw --host=$mysql_host --port=$PORT --user=$mysql_user --password=$mysql_pwd $BINLOG_FILE > "${bin_log_dir}/${BINLOG_FILE}"
done

find $bin_log_dir -type f -name "mysql-bin.0*" -mtime +7 -delete

echo 6666