UBB.Developers Forums Community Development Programming MySQL and Server Configuration Daily db backups?

I'd like to automate daily backups of all of our forum tables. Config is:

Linux 7.3
MySQL 3.23
Threads 6.3.2 (going to 6.4 within a few days)

Speak slowly - I am not a server admin! We do not have phpMyadmin or whatever it's called.

I'm thinking the backup needs to be in cron. But I thought the forums had to be closed to do a full backup of everything? I'd like to make a tarball out of it too so I can dl or ftp daily.

Anyway, I'm rambling. I hope what I want to do is clear, and any help is appreciated.

No I don't believe the forum needs to be closed to do a mysqldump. (yes if you're going to optimize).

I use phpMyBackup and setup a cron to backup the databases nightly.

You can even set it up to FTP them to another server.

This just does the database, you'd need to tar/backup your threads directory via commandline and download.

There are many auto backup utilities out there

I use something called automysqlbackup.sh

which tar/gz's them

It is a freeware program and you can search for it by name

Thank you guys for the help. While searching before posting, I found that phpmybackup and will give that a shot.

Thanks again!

Could you share with us the cron file?

It's that link I posted above for phpMyBackup - instructions are in the docs at sourceforge.

http://sourceforge.net/docman/?group_id=87466

Ahhh. .so it's a case of RTFM.

I run this in Cron daily on Fedora Core 1
This gets a dump and compresses it to a file using the YearMonthDayHourMinuteSecond-myDatabsename-db.sql.gz as the filename so it is easy to get the latest backup and it is compressed etc. My Backup directory is stored below the document root and is on a name based virtual host. I run the Cron Job as the website user. Hope this might help someone maybe.

[]Omegatron said:
There are many auto backup utilities out there

I use something called automysqlbackup.sh

which tar/gz's them

It is a freeware program and you can search for it by name [/]
Chuck,

This is the one that you setup for me and I really like it

Is there a way to have it email the backup verse storing it on the server so that if something happens again at vertex hosting, like earlier this week, I can pull the backup out of my email?

Thanks,

BWilliams

I use the phpmybackup like Josh #1 suggested. It has a feature that will FTP the backup to any server you specify. I setup an FTP server on my home computer and I have it FTP the backup here every morning when it runs. Now THAT'S off-site storage!

automysqlbackup.sh does not ftp the backups