I haven't actually cracked this yet, but hopefully with the input of some forum members we can get to a solution that others will find useful in the future.
I backup my wordpress blogs with:
WordPress Database Backup
But I have a wpmu site which I haven't found a suitable solution for and also some other sites which are mysql based that I want to backup, I think the best way is to set up a CRON job, which I can do on some sites via ssh or via the cpanel menu on some others. So he are some codes snippets I have found so far:
/usr/local/bin/mysqldump --default-character-set=utf8 --user=username --password=password --quote-names --complete-insert --extended-insert --quick --compact --lock-tables=false --skip-add-locks --all-databases | gzip > /home/path/backup/`date "+%Y.%m.%d"`.gz
I can't say I have much of a clue how to use the code snippets yet, or how to even get started emailing myself a backup, but I'll get there eventually, maybe even with some of your help, so if you know what you are doing can you help me out
My idea is to have 7 backups on my site at any one time. Number 1 through 7 they get overwritten weekly, so as to not been storing too much. I also want to email myself the backup on a weekly or daily basis depending on which of my sites it is.
I think that if I can use `date "+%d"`it will give me a backup for each day of the month, I know in php
w gives me a numeric representation of the day of the week, which is what I
am after here, not sure if it is the same for a cron job though.
Anyway I'm off to do some more digging, if you can help with any of this, let me know, I'm learning as I go here.
