mysql数据库备份

[root@mysql86 ~]# cat /root/mysql_dump.sh

#!/bin/sh

set -x

shlog=/mydata/databake/rm_olddata.log #删除记录日志

time=`date +%Y%m%d`

time1=`date +%m%d%H%M`

data_path="/mydata/databake/" #备份目录

find $data_path/ -type d -ctime +90 -exec rm -rf {} \; #保存90天

echo "[$(date +%Y%m%d%H%M%S)] No Old File!">>$shlog

mkdir $data_path/$time

/usr/local/mysql/bin/mysqladmin -uroot -p"`cat /root/dbpass`" flush-tables

for db in `awk '{print $1}' /root/dblist.txt`

do

/usr/local/mysql/bin/mysqldump -uroot -p"`cat /root/dbpass`" $db > $data_path/$time/$db-$time1.sql

done

/bin/gzip $data_path/$time/*.sql