> ## Content Index
> Fetch the complete content index at: https://blog.k3s.9zf.net/llms.txt
> Use this file to discover other available public pages before exploring further.

# Dreamhost自动备份至邮箱和Godaddy免费空间成功手记
- URL: https://blog.k3s.9zf.net/dreamhost-e8-87-aa-e5-8a-a8-e5-a4-87-e4-bb-bd-e5-8f-91-e9-80-81-e5-88-b0-e9-82-ae-e7-ae-b1-e6-88-90-e5-8a-9f/
- Published: 2010-04-13T05:58:44.000Z
- Updated: 2010-04-13T05:58:44.000Z
- Author: liu
- Tags: Linux, web服务器, #wordpress, #Import 2026-10-29 06:11

做下笔记  
以下为数据库的备份发送到邮箱  
首先用ssh创建两个目录

> cd \~  
> mkdir backups  
> mkdir backups/archives 

然后是定时执行的脚本mysql.sh

> #!/bin/bash  
> cd /home/qxwo/backups/  
> mkdir mysql  
> suffix=$(date +%y%m%d)  
> mysqldump –opt -u用户 -p密码 -h mysql.xiacai.com.cn xiacai > mysql/xiacai.$suffix.sql  
> tar zcf archives/mysql\_backup.$suffix.tar.gz mysql/\*  
> rm -r mysql/  
> mutt qxwo@qq.com -a /home/qxwo/backups/archives/mysql\_backup.$suffix.tar.gz -s “MySQL Backup” 

赋予权限

> dos2unix mysql.sh  
> chmod 755 mysql.sh 

最后在Dreamhost的面板里添加定时执行  
Goodies->Cron Jobs中新建Cron任务，选项设置为  
Command to run: /home/qxwo/backups/mysql.sh

下面开始文件的自动备份,俺上述方法不能发送到邮箱不知道为什么,可能数据太大的原因吧,于是想到了用godaddy的免费空间做ftp备份

创建脚本ftp.sh

> #!/bin/bash
> 
> cd /home/qxwo/  
> sx=$(date +%y%m%d)  
> tar zcf backups/archives/web\_backup.$sx.tar.gz xiacai.com.cn/\*  
> cd /home/qxwo/backups/archives/  
> ftp -vn xiacai.net << autoftp user 用户 密码 type binary put web\_backup.$sx.tar.gz web\_backup.$sx.tar.gz close quit autoftp 

同上添加定时执行脚本…  
成功,上图[![](https://blog.k3s.9zf.net/content/images/wordpress/2010/04/QQ%E6%88%AA%E5%9B%BE%E6%9C%AA%E5%91%BD%E5%90%8D-300x128.jpg "QQ截图未命名")](https://blog.k3s.9zf.net/content/images/wordpress/2010/04/QQ%E6%88%AA%E5%9B%BE%E6%9C%AA%E5%91%BD%E5%90%8D.jpg)  
我已经拒绝了tar.gz的访问权限,不要试图去下载我的备份!

>  
> Deny from All