On Wed, May 30, 2001 at 11:33:50PM -0700, Matt Templeton wrote:
>
> I've read the documentation but can't seem to find a clear answer to
> this...
>
> If I set up a table that has and auto-increment ID table and insert
> a number of records that are incremented in sequence. Then I delete,
> say the 5th and the 8th row and do a full (database creation and
> data) mysqldump.
If you can tell me where in the docs you expected to find the info,
I'll gladly work up a patch for the docs.
> Now, if I use the dump to rebuild the database and restore the data,
> will the ID numbers recorded in the dump be used or will the ID
> numbers be renumbered? I'm wondering because restoring from a dumb
> file uses and sql INSERT to restore each record....
Try it any see. :-)
The ID numbers will not change. mysqldump will dump out the actual id
values rather than putting a NULL or some other place-holder in there.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 5 days, processed 35,324,726 queries (72/sec. avg)
---------------------------------------------------------------------
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