At 21:13 +0100 8/30/02, Mike Hall wrote: > > 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.
He means (I think): the server has to regenerate the indexing into the data rows when the rows are loaded back into the table. That takes time. > >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
