#!/bin/sh cd /root #dump the DB /usr/local/bin/mysqldump --opt --user=hxs --password=****** --host=localhost hxs > hxs.sql /usr/local/bin/mysqldump --opt --user=hxs --password=****** --host=localhost blog > blog.sql #tar the file tar -zcvf hxs.sql.tar.gz hxs.sql tar -zcvf blog.sql.tar.gz blog.sql tar -zcvf hxs.tar.gz /usr/local/www/apache24/data/hxs tar -zcvf blog.tar.gz /usr/local/www/apache24/data/blog #upload to the FTP ftp -v -n dedibackup-dc2.online.net << EOF user sd-66666 ****** type binary cd /backup put hxs.sql.tar.gz put hxs.tar.gz put blog.sql.tar.gz put blog.tar.gz bye EOF #del the local file rm -rf /root/*.tar.gz rm -rf /root/*.sql
save the code below as backup.sh under the /root
run:
chmod +x /root/backup.sh
run:
crontab –e
add:
00 05 * * * /root/backup.sh