基于linux系统下的MYSQL自动备份

so_brave

基于linux系统下的MYSQL自动备份

编辑 脚本文件

1. db_user="root"
   
2. db_passwd="123456"
   
3. db_host="localhost"
   
4. backup_dir="/usr/local/apache2/htdocs/backup"
   
5. time="$(date +"%Y%m%d%H%M")"
   
6. MYSQL="/usr/local/mysql/bin/mysql"
   
7. MYSQLDUMP="/usr/local/mysql/bin/mysqldump"
   
8. MKDIR="/bin/mkdir"
   
9. RM="/bin/rm"
   
10. MV="/bin/mv"
    
11. GZIP="/bin/gzip"
    
12. test ! -w $backup_dir && echo "Error: $backup_dir is un-writeable." && exit 0
    
13. test ! -d "$backup_dir/$time" && $MKDIR -p "$backup_dir/$time"
    
14. all_db="$($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse 'show databases')"
    
15. 
    
16. for db in $all_db
    
17.   do
    
18.     $MYSQLDUMP "--default-character-set=gbk" -u $db_user -h $db_host -p$db_passwd $db | $GZIP -9 > "$backup_dir/$time/$db.gz"
    
19.   done
    
20.     exit 0;
    

复制代码

设置定时任务

使用crontab -e命令编辑定时任务列表

1. 15 3 * * * sh /usr/scripts/mysql_backup.sh

复制代码

表示每天凌晨3点15分执行该脚本进行数据库备份

小忻黑夜

谢谢分享

Shell_HAT

1. 15 3 * * * sh /usr/scripts/mysql_backup.sh >/usr/scripts/mysql_backup.log 2>&1

复制代码

lastfile

收下收下