Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: russs on May 03, 2007, 10:46:19 AM

Title: Scheduled FTP Backup
Post by: russs on May 03, 2007, 10:46:19 AM

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

Title: Scheduled FTP Backup
Post by: byte on May 03, 2007, 10:53:57 AM

Have you had a look at...

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

Title: Re: Scheduled FTP Backup
Post by: skydivers on May 03, 2007, 11:12:16 AM

Quote from: "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)

Title: Scheduled FTP Backup
Post by: russs on May 03, 2007, 11:13:11 AM

Thanks for the prompt reply byte, looks interesting.

Title: Re: Scheduled FTP Backup
Post by: russs on May 03, 2007, 11:56:33 AM

Quote from: "skydivers"

Quote from: "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.

Title: Re: Scheduled FTP Backup
Post by: skydivers on May 03, 2007, 11:58:16 AM

Quote from: "russs"

Quote from: "skydivers"

Quote from: "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.

Thanx a lot!