mysql全備份

#!/bin/bash

mkdir /backup

cd /backup

dateDIR=`date +"%y-%m-%d"`

mkdir -p $dateDIR/data

for i in `mysql -uroot -p123456 -e "show databases" | grep -v "Database"`

do

mysqldump -uroot -p123456 --default-character-set=gbk --opt $i | gzip > /backup/$dateDIR/data/${i}_${dateDIR}.sql.gz

done

binlog_rm=`tail -n 1 $path/mysql-bin.index | sed 's/.\///'`

mysql -uroot -p123456 -e "purge binary logs to '$binlog_rm'"

本文轉自 liang3391 51CTO部落格，原文連結:http://blog.51cto.com/liang3391/456627