標題: MySQL 之備份 [打印本頁] 作者: bestlong 時間: 2006-9-7 09:43 標題: MySQL 之備份
網路上找到的運用 GMail 異地保存備份資料的方法
#!/bin/sh
DATE=`/bin/date +%Y%m%d`
/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 時間: 2006-9-7 10:01
外國人寫的 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..