Automated backups + Linux + rsync?

[kursed]

Can anyone here help me set up a cron job for doing a daily mysql dump of my forum's dbase and rsync for it at bqbackup.

I'm not too sure, if this is the forum to ask such questions at. But I'm looking forward to you folks helping me out.

[Amenadiel]

I have this dbbackup.sh in my /root folder which contains:

fecha=`date +%Y-%m-%d`

mkdir /var/.backupsql/bd-$fecha

rsync -a -p -o -g /var/lib/mysql/vb/ /var/.backupsql/bd-$fecha/.

and an entry in the crontab telling it to run daily at 4am

0 4 * * * /root/backup.sh > /dev/null

In my experience, mysqldump was slower than this procedure, and so far (almost a year now) I haven't had any complications with corrupted tables whatsoever.

[Lynne]

I use this mod - Automatic Database Back-up and throw the backups in a /dbbackups folder which is then rsynced to bqbackup. Every couple of days I go in and move the backups to another folder on my server (and delete some old ones).

[Quarterbore]

I do mine like this:

http://www.vbclassified.com/showthread.php?t=241

Perhaps I should be using rsinc instead of a full copy?

http://rsync.samba.org/