We use mybackup.pl - a perl script found on sourceforge (well, not anymore I just looked). It creates a compressed tarball of each database, with a file for each table. The files can be used with the mysql client without change to rebuild a table. It also can be setup to rotate the backups based on date. You can also have the data emailed if so desired.
http://worldcommunity.com/opensource/ Mike -----Original Message----- From: Kory Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 1:27 PM 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
