备份
我们使用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
