it really helps too if you have a compression utility to zip your database before sending it to the backup server (or whatever).
databases compress to really high ratios most of the time (: ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 9:18 PM Subject: RE: Witango-Talk: [OT] Online Backups? > 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
