At 3:15 AM -0500 9/3/99, Joshua Chamas wrote:
>In case of disaster, I would like to have all my tables
>backed up in the form of an export, which I would be
>able to later import. What's faster, creating a table
>with its indexes, then import, or create/import and
>add indexes later.
>With Oracle, it was always recommended to create
>an index on the table after a large table import, but
>MySQL might be different ? I'm talking about a table
>on the order of a 1 gig, so a difference of 50%
>might shave off a few hours of downtime if I should
>need this form of recovery.
It's the same for MySQL; create the indexes after importing
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/