Automated DB backup and FTP

[Time]

I'm running a CentOS 5 Dedicated Server (no control panel, preferably won't install one).

I'm wanting to be able to have a automated MySQL database backup every 12 hours and uploaded to a VPS via FTP, how would I be able to do that?

Thanks.

 

[bxflow]

are you using any scripts?
in vbulletin theres a plugin which takes an automatic backup then later on you can ftp that backup or transfer it to another server but im not sure on how you would go about making it go straight ftp etc

 

[Time]

I don't have anything like that running on the Dedicated Server, it's for a game.

 

[kenshin]

what cms are u using? (if any)...most cms have plugins for this purpose

 

[Lock Down]

Use mysqldumper. It will do all that for you automatically.

 

[KaFo]

Well I would do this with a cron job executing every 12 hours and a small bash script:

#! /bin/bash
mysqldump -u username -h localhost -p password database_name | gzip -9 > backup_db.sql.gz
wput backup_db.sql.gz ftp://user:pass@host

First line does a Backup of your database and compresses it.
Second line uploads compressed file to another server via ftp.

KaFo

 

[Lock Down]

Remember wput is not standard on all servers and would have to be installed.

 

[KaFo]

@Lock Down yes that is true:-)

But Time mentioned he has a deddi, so installing additional software shouldn't be a prob ;-)

KaFo

 

[Whoo]

Why not just take the backup and SCP it to the VPS? Why would you need FTP? =/

 

[Lock Down]

@KaFo * true if he knows he has to do it.

@Whoo * I am assuming he wants it offsite somewhere. Not on the same server.

He could scp instead of ftp or wput or ?? Just what a person knows that make them feel comfortable.