Easiest way to backup to remote FTP

[BlackStorm]

Hey,
I want to backup the HT database daily to a remote FTP.
Its changing everyday, sometimes by a lot so me manually backing up isnt cutting it anymore.

I want to back it up to a remote server and put it on an FTP account.

What is the quickest and easiest (least resource intensive) way of doing this?

Would doing it through a cron job be the best way?

Could you all give me some options of what I can do, and how to do it would be helpful

Benefits of each option would be great, I will most likely be using that for a very long time to keep backing up the database manually.

 

[AvidaO]

why ftp back it up to some locked down server with only ssh and apache via wget,

 

[turnkey]

look on forums.ev1servers.net there are several programs that do that. I wrote one a while ago but not sure where I placed the source. Will look for it.

It does a complete site backup and SQL backup to a remote FTP server.

Now, time to look for the archive.

 

[BlackStorm]

Thanks a lot Robert, the main thing is just the database as everything is stored in the database really, most things that are updated on the site are PHP scripts which use MySQL so the info isnt changed in any files, apart from the SQL.

It wouldnt cause any problems if it backed up the files also though

Thanks
John

 

[GordyMac]

This stuff is way out of my league

 

[turnkey]

John,

Sorry for the delay. Been working on a customer program but I will try to look for it this weekend. If not, I will write it. As I remember it was not very hard to write.

Robert

 

[BlackStorm]

ok thanks a lot Robert, would love a script that can do it for me

Time to backup now anyway, forgot all about it until I read this

 

[GordyMac]

A remote backup script would be ideal, maybe you could include something like that in Source Matrix?

 

[turnkey]

John,

Ok, going to work on something tonight for a remote backup.

 

[BlackStorm]

Thanks a lot Robert,
Looking forward to seeing the script, will put it to use ASAP also

Thanks!

 

[GamesCreation]

Did you get the script? This is something that would be really useful for me as well

 

[HS Nick]

You know John, im suprised no one has said this yet. Why dont you just use the backup script built into WHM ? You can configure it to backup to a remote ftp server. And it doesnt it automaticlly. and you can chose to do it daily,weeks,Monthly. at what time, and all that good junk.

 

[GamesCreation]

Does it only back up hias account, or all accounts (as it's in WHM) ?

 

[HS Nick]

You can choose, i believe.

 

[GamesCreation]

Pretty useful. Shame though, if the functionality is there for the web hosts, why cant they add it for the clients?

 

[HS Nick]

I believe that John has WHM so he can do this. as he is either a reseller or its his server. not sure but i know he has WHM access.

 

[GamesCreation]

I know, but it would be nice if users could do this as well. We have sites we want to backup as well

 

[BlackStorm]

Ok just going to be installing Robert's script today, had a lot to do all week with moving the site over.
I do have access to the root WHM so I will check about backing up one site that way, but its only the sql db i want to backup and not all files in the site, would use quite a lot of bandwidth to backup everything because theres so many files.

BTW, where is that option in WHM nick?
Cant see it listed anywhere here

 

[HS Nick]

Its called Configure Backup.

The owner of the server may not have that option allowed for you.

 

[GamesCreation]

Doesnt John own his own servers?