MySQL 之備份

bestlong

網路上找到的運用 GMail 異地保存備份資料的方法

1. #!/bin/sh
   
2. DATE=`/bin/date +%Y%m%d`
   
3. 
   
4. /usr/local/bin/mysqldump -A -u root --password=PASSWORD | gzip -9 | uuencode mysql-${DATE}.gz | gpg -a -e -r gslin | mail -s “evil.NCTU.edu.tw MySQL backup (${DATE})” evilGMAIL@gmail.com

複製代碼

bestlong

外國人寫的 Script

A script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-mail logs - More..

http://members.lycos.co.uk/wipe_out/automysqlbackup/
http://sourceforge.net/projects/automysqlbackup/

bestlong

vim /root/mysql_backup.sh

1. #!/bin/sh
   
2. FILENAME=`date "+dbname-%Y%m%d"`.sql
   
3. 
   
4. /usr/bin/mysqldump -u root dbname > ~root/${FILENAME}
   
5. 
   
6. /usr/bin/ncftpput -u test -p 111111 192.168.1.100 ./ ~root/${FILENAME}

複製代碼

更改檔案權限
chmod 700 /root/mysql_backup.sh

將 /root/mysql_backup.sh 放入排程