If your database is very large, this will take a while moving the db over the internet. Even with a T1 or T3 if you have a db very large, it will take a long time to back up. I suppose if you do a local copy first and then move the copy to the backup server might work.
I do it simelar to Dave on R:tango. I use a batch file run with the AT command so every night at 1:00am, it does a Net stop tango_2000_server, copies the db to another drive on another server, and then starts tango back up. I am not as polite as Dave and don't put a message up, I just stop it, but it runs so fast the users just have to wait a few seconds w/o a response. No one has ever complained, so I have not worried about it. I back up the copy to tape which gets rotated off site. Troy -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 12:29 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: [OT] Online Backups? Ok :) Another clarification: There are sites/services on the web that have storage space or will do backups for you. Is anyone here using one of those sites/services. I can find them by doing a search, I am just wondering if there are sites the some on the list have used and could say great site or stay clear. Thanks all for the replys Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Witango Developement -----Original Message----- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 1:40 PM To: Witango-Talk Subject: RE: Witango-Talk: [OT] Online Backups? I use mysqldump via a shell script. You can also set up webmin to automatically backup your database. For remote backup on *nix, just use rsync. >Dev, > > Can you send me the code snippet. I am facing similar problems. > >Thanks, >Murugapiran Natan. > >-----Original Message----- >From: Dave Shelley [mailto:[EMAIL PROTECTED] >Sent: Thursday, January 22, 2004 10:12 PM >To: [EMAIL PROTECTED] >Subject: RE: Witango-Talk: [OT] Online Backups? > > >Ben, > >I do my backups with witango. > >I wrote a little taf file that: >1) sets a domain scope variable so users get a nice message saying >please come back in a couple of minutes, with a javascript refresh to >help >2) shuts down MySQL >3) copies the databases, taf's, tcf's, images etc. to another disk >4) restarts MySQL >5) restarts the witango services > >It could also zip the backed up files and push them to an ftp server, >but that's one for version 2. > >Dave > >-----Original Message----- >From: Ben Johansen [mailto:[EMAIL PROTECTED] >Sent: January 22, 2004 10:01 AM >To: 'WiTango List' >Subject: Witango-Talk: [OT] Online Backups? > >Hi, > >Anyone have experience with online backups and have a service they like? > >Ben Johansen - http://www.pcforge.com >Authorized Witango & MDaemon Reseller >Available for Witango Developement > > > > >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
