Here is some comments about backup (Windows). The best way as I find it is always to back up the database locally to another disk on the same server or to an other server. Using MSSQL or Pervasive, and I'm sure other databases to it's possible to do it online while the database is up and running.
Then if you want to copy the backup (files) to another server over the internet there are tools for it. One free and very god one is BackupGenie, se http://backupgenie.nerim.net// With BackupGenie you create scheduled jobs that automatically copy files/folders to a destination on LAN/WAN/Internet(FTP). The good thing is that it create a zip file for each job at the destination. The jobs can also be incremental. I use it on my laptop, copying my developing folders automatically each day to the server as zip files without having to think about backups. The only back draw is when I' am working offline it yells at me that the connection is broken and I have to manually click on the icon on the taskbar to stop it. So with that tool and an online backup set up on your database it should be easy to fix the job without programming anything yourself (for a change) if the amount of data is ok to send over your connection. Of course there is also the possibility to install and run a replication service but that�s expensive and works differently between database vendors. Bengt Bredin ----------------------------------------------------------------------- LabIT Solutions AB -----Ursprungligt meddelande----- Fr�n: Troy Sosamon [mailto:[EMAIL PROTECTED] Skickat: den 23 januari 2004 06:18 Till: [EMAIL PROTECTED] �mne: 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
