Topic: Scheduled FTP Backup

[russs]

Hi all,

haven't posted here for a while, no need to as SME just works so well!

Thing is, I have SME set up on several servers at our building now.

For example our Database server is running with MySQL and I have a great little script I found that backs up the SQL databases on it daily, weekly or monthly. This works really well and allows me to save the backup anywhere on the server or on the local network. Trouble is I would like an off-site backup and to save me the hassle of taking home a DLT tape each day (and remembering to bring it back again) I would like to send the backup by FTP to my home server. The compressed SQL backup is only about 14MB so it's not huge. I have another SME server at home to receive it so this could be by SFTP too as it is set to allow SSH and FTP.

The script allows a command to be run before or after backup so can anyone tell me a simple command that would allow me to do this (backup up through FTP or SFTP to a remote location) or is there an alternative better way of doing this?

Running on SME 7.1.

Thanks

Russ

[byte]

Have you had a look at...

http://forums.contribs.org/index.php?topic=36499.0

[skydivers]

I found that backs up the SQL databases on it daily, weekly or monthly.

I'm looking for something simular. Could you send me in the right direction to the script? (eg. URL)

[russs]

Thanks for the prompt reply byte, looks interesting.

[russs]

I found that backs up the SQL databases on it daily, weekly or monthly.

I'm looking for something simular. Could you send me in the right direction to the script? (eg. URL)

Got it here;

http://sourceforge.net/projects/automysqlbackup/

Works really well. Instructions included in script file.

[skydivers]

I found that backs up the SQL databases on it daily, weekly or monthly.

I'm looking for something simular. Could you send me in the right direction to the script? (eg. URL)

Got it here;

http://sourceforge.net/projects/automysqlbackup/

Works really well. Instructions included in script file.

Thanx a lot!