VPS侦探论坛

标题: 军哥您帮忙看看这样写对吗？ [打印本页]

---

作者: 68218866    时间: 2011-12-6 09:37
标题: 军哥您帮忙看看这样写对吗？

1. [root@localhost /]# vi mysql-backup.sh
   
2. db_user="root"
   
3. db_passwd="123456"
   
4. db_host="192.168.1.110"
   
5. db_name="ecshop"
   
6. # the directory for story your backup file.
   
7. backup_dir="/backup"
   
8. # date format for backup file (dd-mm-yyyy)
   
9. time="$(date +"%Y-%m-%d-%H-%M-%S")"
   
10. # mysql, mysqldump and some other bin's path
    
11. MYSQL="/usr/local/mysql/bin/mysql"
    
12. MYSQLDUMP="/usr/local/mysql/bin/mysqldump"
    
13. GZIP="/bin/gzip"
    
14. $MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db_name | $GZIP -9 > "$backup_dir/$db_name"_"$time.gz"
    
15. 
    
16. 
    
17. 让备份脚本每天自动执行
    
18. 
    
19. # crontab –e
    
20. 
    
21. # 00 03 * * * /mysql-backup.sh // 每天凌晨3点执行

复制代码

---

作者: licess    时间: 2011-12-6 09:53
对

---

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)

Powered by Discuz! X3.4