DB-MySQL 备份

最新推荐文章于 2024-10-13 21:08:42 发布

大大的芒果

最新推荐文章于 2024-10-13 21:08:42 发布

阅读量249

点赞数

文章标签： mysql shell 备份脚本

本文链接：https://blog.csdn.net/oz965557340/article/details/77413851

版权

数据库同时被 2 个专栏收录

4 篇文章 0 订阅

订阅专栏

Linux

3 篇文章 0 订阅

订阅专栏

备份

我们使用MySQL原生备份命令，编写shell脚本命令，当然我们也可以使用python

#!/bin/sh 
cd /bak/bakmysql
echo "You are in bakmysql directory"
mv bakmysql* /bak/bakmysqlold
echo "Old databases are moved to bakmysqlold folder"
Now=$(date +"%d-%m-%Y")
File=bakmysql-win-$Now.sql
mysqldump -uroot -p'root' win > $File   
echo "Your database backup successfully completed"
SevenDays=$(date -d -7day  +"%d-%m-%Y") 
if [ -f /bak/bakmysqlold/bakmysql-win-$SevenDays.sql ]
then
rm -rf /bak/bakmysqlold/bakmysql-win-$SevenDays.sql
echo "You have delete 7days ago bak file "
else
echo "7days ago bak file not exist "
fi