MySQL自动备份还原脚本
Published on 2015 - 09 - 05
备份脚本
DIR=/opt/database
FILE_NAME=`date +%y%m%d%H`
FILE_NAME=$DIR/db_$FILE_NAME.sql
echo start backup to $FILE_NAME
sudo mysqldump --host=yourDB_URL --port=3306 --user=yourusername --password=yourpassword yourdbname > $FILE_NAME
echo finish backup
还原脚本
DIR=/opt/database
FILE_NAME=`date +%y%m%d%H`
FILE_NAME=$DIR/db_$FILE_NAME.sql
echo start restore to $FILE_NAME
mysql rich < $FILE_NAME -uyourusername -pyourpassword
echo finish restore