GoFuckYourself.com - Adult Webmaster Forum - Who can tech me how to do cron jobs to copy files?

just create a shell script and execute it.

(once a day)

0 0 * * * /home/user/wpbackup.sh

Code:

#!/usr/bin/bash



date="`eval date +%Y%m%d`";

mysqluser="mysqluser"

mysqlpass="mysqlpassword"

mysqldb="blogdatabase"

backupsource="/home/user/public_html/"

backupdest="/home/user/backups/"



echo "creating database backup"

mysqldump -q -e -h localhost -u ${mysqluser} -p${mysqlpass} ${mysqldb} | gzip - > ~/${backupdest}${date}_db-backup.sql.gz

echo "done"

echo "creating file system backup"

cd ~/${backupsource}

tar cf - . | gzip - > ~/${backupdest}${date}_files.tar.gz

echo "done"

echo "wordpress backup complete"