Script to Backup MySQL Database on Server Automatically ?

Hammad101 · 12-23-2008, 10:34 AM

Hi.

I have a Debian etch server and looking for some automatic ways to backup a vBulletin Mysql Database daily or 12-Hr.

I'm not concerrned about auto-backup slowing down the server for the duration of back (well read somewhere).

also I would want the filename to be date-based.

maybe a bash script or something ... as i would like to add the following in it too

Code:

perl rsapi.pl {sql filename dumped}

so the DB gets uploaded to my rapidshare account automatically.

any help will be greatly appreciated.

repo · 12-23-2008, 10:39 AM

You can use tar and cron

trickykid · 12-23-2008, 10:54 AM

Code:

#!/bin/bash
#

date=$(date +%F)
backupdir=/some/dir/to/place/backups/to

cd $backupdir
/usr/bin/mysqldump -u <username> -p<password> --databases <database> > database-name_$date.sql
gzip database-name_$date.sql # optional to compress

It's simple but works. Play around with it and come up with something that suits to your needs.

Hammad101 · 12-23-2008, 10:55 AM

Quote:

Originally Posted by repo

You can use tar and cron

thanks for the reply but if i knew CORN ......

i've updated the OP also.

Hammad101 · 12-23-2008, 11:03 AM

thanks alot trickykid.

I'll check it out and let you know.

Hammad101 · 12-23-2008, 11:20 AM

ok it works great!

thanks again

but how do i setup a CORN JOB for it?

sorry i've got no idea.

trickykid · 12-23-2008, 11:54 AM

Quote:

Originally Posted by Hammad101

ok it works great!

thanks again

but how do i setup a CORN JOB for it?

sorry i've got no idea.

Either throw it in your /etc/cron.daily or /etc/cron.hourly folders if you have those available or manually setup the cron job by doing a crontab -e

Hammad101 · 12-23-2008, 12:52 PM

Thanks a lot mate.

This is what i'm going to use.

Code:

59 23 * * * /usr/bin/backup >> /var/log/db.backup.log 2>&1

Will backup every day @ midnight. and maintain a log too.
(posted if someone else stumbles across might be of some help)