MySQL 之備份
網路上找到的運用 GMail 異地保存備份資料的方法[code]#!/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
[/code] 外國人寫的 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/
備份 MySQL 並使用 FTP 做異地備份
vim /root/mysql_backup.sh[code]#!/bin/sh
FILENAME=`date "+dbname-%Y%m%d"`.sql
/usr/bin/mysqldump -u root dbname > ~root/${FILENAME}
/usr/bin/ncftpput -u test -p 111111 192.168.1.100 ./ ~root/${FILENAME}[/code]
更改檔案權限
chmod 700 /root/mysql_backup.sh
將 /root/mysql_backup.sh 放入排程
頁:
[1]