> b) I have 200 tables. I don't want to have to recreate indexes for > every table if I have to restore. I'd rather spend an hour restoring > from tape and let replication catch me up.
Why would you have to recreate the indexes? The dump will contain this information in the CREATE statements. Mike [sql,query] --------------------------------------------------------------------- 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