Having worked with Oracle, and MS SQL databases, the only "backup/recovery" I usually deal with after the admins have their dumpdb run to a secondary transaction database is tape backup of some form. Most of the sites I have worked with however use 3 disk mirrors, and disk cloning, and disk snapshots every so often as their needs demand. The key they find is the brief database lock, and the quiessing of the databases just prior to the spanshot or breaking off of the clone allowing for the backup with nor performance degradation of their active database.
I don;t know your budjet or application or even if I am making any sense, but this is how we have been working the issue of backups of databases. Mark ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Chetan Lavti" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 9:31 PM Subject: Re: MySQL Backup and Recovery > On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: > > > > Hi, > > > > I am planning to have MySQL database backup and recovery from the > > web interface. Is it possible to do this. If yes, then what > > procedure I should follow. If anybody have any idea about this then > > please, do help me. It's our requirement. > > Backup and recovery is a common topic on this list. Have you scanned > the archives yet? > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 23 days, processed 764,260,032 queries (376/sec. avg) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php