Hi. First, when you start an independend question, please start a new thread, but at least change the subject accordingly.
On Fri 2002-07-26 at 11:07:17 +0300, [EMAIL PROTECTED] wrote: [...] > If table recreated from table.frm why it not recreate indexes file? Because this is the documented behaviour: http://www.mysql.com/doc/C/R/CREATE_TABLE.html ;-) More seriously, it is explained in the cited section: "[...] CREATE TABLE ... SELECT will not automatically create any indexes for you. This is done intentionally to make the command as flexible as possible. If you want to have indexes in the created table, you should specify these before the SELECT statement" Greetings, Benjamin. -- [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