linux下备份数据库 sh脚本

mkdir backup

mkdir oldbackup

vi /backup.sh

#!bin/bash
cd /home/backup
echo "You are In Backup Directory"
mv backup* /home/oldbackup
echo "Old Databases are Moved to oldbackup folder"
Now=$(date +"%d-%m-%Y--%H:%M:%S")
File=backup-$Now.sql
/alidata/server/mysql/bin/mysqldump -uroot -proot ainiu_test > $File
echo "Your Database Backup Successfully Completed"
find /home/oldbackup/ -mtime +30 -name "*.sql" -exec rm -rf {} \;
echo "Clear Successfully "
cd /

chmod +x /backup.sh 

设置定时任务

crontab -e

每天凌晨3.30执行sh脚本

30 3 * * *  /backup/backup.sh