Hello Tab, Friday, March 29, 2002, 10:05:20 PM, you wrote:
Which table type do you use ? Well if you do not know it's probably MYISAM. In this case you may use BACKUP TABLE to make a quick consistent backup of the table. If you want to have consistent snapshot of several tables you may use "lock tables" with BACKUP table. Also mysqldump --tab will work for any table type and it's rather fast. TA> What do you folks out there do to backup your MySQL databases? I'm new TA> to it and am wondering if there's a good utility for doing it, or some TA> simple procedure that is already known to be effective and efficient. TA> TA> Thanks, TA> Tab TA> --------------------------------------------------------------------- TA> Before posting, please check: TA> http://www.mysql.com/manual.php (the manual) TA> http://lists.mysql.com/ (the list archive) TA> To request this thread, e-mail <[EMAIL PROTECTED]> TA> To unsubscribe, e-mail <[EMAIL PROTECTED]> TA> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Peter mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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