Thank you very much !! I have a management screen, where I have two button namely "BACKUP" and "RECOVERY". I am not able to find out, how this will be done(both BACKUP and RECOVERY)?, when I click on the corresponding buttons and while doing this if error occurs, how I will handle them?. Moreover, between these two methods which one to use (keeping in mind the advantages and disadvantages of both the methods).
Basically, how to link the "BACKUP" and "RECOVERY" procedure with the management screen(HTML page, web) and how to handle the errors occurred during this procedure. Thanks and regards, Chetan Lavti -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 10:19 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: Again regarding MySQL Backup and Recovery On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote: > > I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform. > Now,for this database backup and recovery procedures are given as : > > 1. Taking 'binary' backup of the database. > 2. Using the mysqldump utility > > In the first method we do the following things : > > · Shut down your MySQL database and make sure it shuts down > without errors. > · Copy all your data files into a safe place. > · Copy all your InnoDB log files to a safe place. > · Copy your `my.cnf' configuration file(s) to a safe place. > · Copy all the `.frm' files for your InnoDB tables into a safe > place Yes, in fact, it looks like you grabbed that right out of the InnoDB docs. :-) > And the second method is just a utility which is to run without > shutting down the server.(with the disadvantage of slower speed of > the Backup and recovery) > > Am I right ?? Yes. > Actually I am new to this field and I want that this is to be done > through the Web. How should I do that.?? What does "through the web" mean? You want to initiate the backups via a web page? You want to be able download the backup files that way? Something else? Tell us what you're trying to do and we'll try to help. 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 24 days, processed 812,615,871 queries (382/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
