Linux下 MYSQL 定时备分脚本
Linux下 MYSQL 定时备分脚本
1 创建备份目录 /backup/mysql
[root@mysqltest1 ~]# mkdir -p /backup/mysql/
2 创建备份脚本backmysql.sh
[root@mysqltest1 ~]# cd /backup/mysql/
[root@mysqltest1 mysql]# ll
total 8
-rwxr-xr-- 1 root root 398 Oct 31 21:16 backupmysql.sh
-rw-r--r-- 1 root root 1870 Oct 31 21:23 testdb20141031.sql
[root@mysqltest1 mysql]# vi backupmysql.sh
#增加以下内容
DB_NAME='testdb'
USER='root'
PWD='123456'
TIME=$(date +%Y%m%d)
DEL_TIME=$(date --date="7 days ago" +%Y%m%d)
DB_BAK_NAME=testdb${TIME}.sql
DB_DEL_NAME=testdb${DEL_TIME}.sql
BACKUP_PATH='/backup/mysql/'
echo $BACKUP_PATH$DB_BAK_NAME
if test -f $BACKUP_PATH$DB_DEL_NAME
then
echo "Delete history dump file"
rm -f $BACKUP_PATH$DB_DEL_NAME
fi
mysqldump -u $USER -p$PWD $DB_NAME>$BACKUP_PATH$DB_BAK_NAME
~
保存退出!
3 配置crontab定期执行脚本
[root@mysqltest1 mysql]# crontab -e
no crontab for root - using an empty one
00 00 * * * root /bakcup/mysql/backupmysql.sh
4 恢复
[root@mysqltest1 mysql]# mysql -uroot -p123456 testdb < /backup/mysql/testdb20141031.sql
1 创建备份目录 /backup/mysql
[root@mysqltest1 ~]# mkdir -p /backup/mysql/
2 创建备份脚本backmysql.sh
[root@mysqltest1 ~]# cd /backup/mysql/
[root@mysqltest1 mysql]# ll
total 8
-rwxr-xr-- 1 root root 398 Oct 31 21:16 backupmysql.sh
-rw-r--r-- 1 root root 1870 Oct 31 21:23 testdb20141031.sql
[root@mysqltest1 mysql]# vi backupmysql.sh
#增加以下内容
DB_NAME='testdb'
USER='root'
PWD='123456'
TIME=$(date +%Y%m%d)
DEL_TIME=$(date --date="7 days ago" +%Y%m%d)
DB_BAK_NAME=testdb${TIME}.sql
DB_DEL_NAME=testdb${DEL_TIME}.sql
BACKUP_PATH='/backup/mysql/'
echo $BACKUP_PATH$DB_BAK_NAME
if test -f $BACKUP_PATH$DB_DEL_NAME
then
echo "Delete history dump file"
rm -f $BACKUP_PATH$DB_DEL_NAME
fi
mysqldump -u $USER -p$PWD $DB_NAME>$BACKUP_PATH$DB_BAK_NAME
~
保存退出!
3 配置crontab定期执行脚本
[root@mysqltest1 mysql]# crontab -e
no crontab for root - using an empty one
00 00 * * * root /bakcup/mysql/backupmysql.sh
4 恢复
[root@mysqltest1 mysql]# mysql -uroot -p123456 testdb < /backup/mysql/testdb20141031.sql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29439655/viewspace-1407577/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Mysql导入导出
下一篇：
用SQL命令查看Mysql数据库大小
请登录后发表评论
登录
全部评论
