Question About Cronjob

Chop Smith · 2004-08-30, 02:55 AM

I have a cronjob set to backup my databases on my server. Is there a way to do a cronjob to cause the backups to be copied to my local?

AcidMaX · 2004-08-30, 07:57 AM

It really depends on what you have on your local machine. I am assuming you have windows. Here is some software that might help you.

http://restkultur.ch/personal/wolf/scripts/db_backup

Now what you could do (if you have a static IP). You could have your host allow you to access the DB from across the network and see if that would script would help, OR you could run that script on your server and it has an ftp function and it will ftp the files to a server offsite.

Me personally I have a Suse linux box here at the house and I Rsync my entire server locally just so I have a backup but since I dont do much with Windows I don't know what they have.

If you can find an Rsync for windows you could use the script above to back it up to your server then rsync it to your windows pc.

Rsync only copies changes.

HTH
Andy

Cleo · 2004-08-30, 08:04 AM

This is how I do it

http://www.cgi-interactive-uk.com/mysql_dump.html

2004-08-30, 02:55 AM	#1
Chop Smith Eighteen 'til I Die Join Date: Apr 2003 Location: Mississippi Posts: 2,168	Question About Cronjob I have a cronjob set to backup my databases on my server. Is there a way to do a cronjob to cause the backups to be copied to my local? __________________

2004-08-30, 08:04 AM	#3
Cleo Subversive filth of the hedonistic decadent West Join Date: Mar 2003 Location: Southeast Florida Posts: 27,936	This is how I do it http://www.cgi-interactive-uk.com/mysql_dump.html __________________ Free Rides on Uber and Lyft Uber Car: uberTzTerri Lyft Car: TZ896289

2004-08-30, 07:57 AM	#2
AcidMaX Programming till my fingers bleed. Join Date: Aug 2003 Location: Michigan Posts: 876	It really depends on what you have on your local machine. I am assuming you have windows. Here is some software that might help you. http://restkultur.ch/personal/wolf/scripts/db_backup Now what you could do (if you have a static IP). You could have your host allow you to access the DB from across the network and see if that would script would help, OR you could run that script on your server and it has an ftp function and it will ftp the files to a server offsite. Me personally I have a Suse linux box here at the house and I Rsync my entire server locally just so I have a backup but since I dont do much with Windows I don't know what they have. If you can find an Rsync for windows you could use the script above to back it up to your server then rsync it to your windows pc. Rsync only copies changes. HTH Andy