1. #!/bin/bash
    2. DAY=`date +%Y%m%d`
    3. SIZE=`du -sh /var/lib/mysql`
    4. echo "Date: $DAY" >> /tmp/dbinfo.txt
    5. echo "Data Size: $SIZE" >> /tmp/dbinfo.txt
    6. cd /opt/dbbak &> /dev/null || mkdir /opt/dbbak
    7. tar zcf /opt/dbbak/mysqlbak-${DAY}.tar.gz /var/lib/mysql /tmp/dbinfo.txt &> /dev/null
    8. rm -f /tmp/dbinfo.txt
    10. crontab -e
    11. 55 23 */3 * * /opt/dbbak/dbbak.sh
    12. #mkdir /mysqlbak 
    13. #mkdir /mysqlbinlog
    14. #service mysqld start
    15. cd /shell
    16. #vi webdb.sh
    17. #!/bin/bash
    18. day=`date +%F`
    19. mysqldump -hlocalhost -uroot -p123 webdb > /mysqlbak/webdb-${day}.sql
    20. mysql -hlocalhost -uroot -p -e "flush logs"
    21. tar zcf /mysqlbinlog.tar.gz /var/lib/mysql/mysqld-bin.0*
    22. #chmod +x webdb.sh 
    23. #crontab -e
    24. 30 23 * * 7 /shell/webdb.sh
    25. #每周日半夜23点半，对数据库服务器上的webdb库做完整备份
    26. #每备份文件保存到系统的/mysqlbak目录里
    27. #用系统日期做备份文件名 webdb-YYYY-mm-dd.sql
    28. #每次完整备份后都生成新的binlog日志
    29. #把当前所有的binlog日志备份到/mysqlbinlog目录下