We use mysqldump. It is fast and easy. restoration is not hard. If you want more a more percise restoration option, look at using the change-log. It wil allow you to revert back in time to a state of the DB. -RG
On Tue, 2 Apr 2002, Kory Wheatley wrote: > Date: Tue, 02 Apr 2002 11:26:58 -0700 > From: Kory Wheatley <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: backup databases > > What is the best method to backup all your MYSQL DATBASES with not a lot > of down time. I have read about using "mysqlhotcopy" and "mysqldump" > are these the best methods. Also what procedure is followed in backing > up the databases. I'm basically looking for the must accurate and > reliable way of doing this. > > -- > ######################################### > Kory Wheatley > Academic Computing Analyst Sr. > Phone 282-3874 > ######################################### > Everything must point to him. > > > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe-##L=##[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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
