hi, 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 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 ?? Actually I am new to this field and I want that this is to be done through the Web. How should I do that.?? Any other alternative procedure for that ..?? Which procedure I should follow..?? please, help me !! Thanks and Regards, Chetan Lavti -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 8:01 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] 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
