Creating Cron Jobs for Daily, weekly backup and optimization

Hi all!
I'm trying to cut down on plugins as I am running 35 plugins and I don't think it's too healthy!

I have a plugin called, 'Automatic WordPress backup' which stores DB, HT Access, Uploads, plugins and themes on an Amazon S3 account which is great but I think a cron job might be a better way to go, rather than using a plugin.

I've never set up a cron job but would love to know if you guys out there use them to back up the DB, plugins and uploads. I would also like to create a job to optimize tables once daily.

Can anyone advise me on how I can go about this so that I can make a comprehensive backup.

I am running WP 3.0 Single install and BP 1.2.4.

Thanks in advance.
Ross :slight_smile:

  • Aaron

    I use s3sync with cron jobs on my server. Here is my db backup script:
    #!/bin/bash
    # script to backup db to s3
    day=
    date +%A
    mkdir -p /home/xxxxxx/public_html/xxxxxx.com/backup/$day
    cd /home/xxxxxx/public_html/xxxxxx.com/backup/$day
    mysqldump --user xxxxxx--password=xxxxxx wordpressmu | bzip2 > xxxxxx.sql.bz2
    ruby /home/xxxxxx/s3sync/s3cmd.rb put mp-backups:db/$day/xxxxxx.sql.bz2 /home/xxxxxx/public_html/xxxxxx.com/backup/$day/xxxxxx.sql.bz2