lftp功能比较强大,各位站长其实可以利用它完成自己网站的备份,参考脚本如下
#!/bin/bash
BackPgName="wordpress.`date +%Y%m%d`.sql"
echo "Begin to back up database wordpress to $BackPgName at `date "+%h %d %H:%M:%S"`"

cd /root/PgDBBack
#pg_dump database wordpress using --insert to avoid the char error
/usr/local/pgsql/bin/pg_dump  -U wordpress --insert wordpress | gzip > $BackPgName.gz

if [ $? -eq 0 ];then
echo "Back up succeed at `date "+%h %d %H:%M:%S"`"
else
echo "Back up failed and exit at `date "+%h %d %H:%M:%S"`"
exit -1
fi

echo "Begin to update database at `date "+%h %d %H:%M:%S"`"
lftp << EOF
open svn.wordpress.net
user idibao passwd
cd pgsqlback
put ${BackPgName}.gz
bye
EOF
mv $BackPgName.gz $BackPgName.Gz
echo "backup succeed at `date "+%h %d %H:%M:%S"`" > /tmp/pgsql_wordpress_bk.log