List:General Discussion« Previous MessageNext Message »
From:Alexander Skwar Date:July 17 2001 9:03pm
Subject:Re: mysqldump loses auto_increment
View as plain text  
So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
> in my plain language there it is, but the pro's may give a more detailed
> approach.

Yeah, that's sorta how I understand it as well.  Also auto_increments
BREAK when you manually insert a row and set the column with the
auto_inc. to 0.  Doing a dump will dump the 0 just fine - but using
the dump to rebuild the table will set the row with the 0 to 1.

In short, my experience is that if you use auto_incs you better do 
*NOT* touch columns with auto_inc values - especially do not modify
them in a way mysql would not have done it itself.

Alexander Skwar
-- 
How to quote:	http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:	http://www.digitalprojects.com   |   http://www.iso-top.de
   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
		Uptime: 14 hours 30 minutes
Thread
mysqldump loses auto_incrementAlexander Skwar17 Jul
  • RE: mysqldump loses auto_incrementWarren van der Merwe17 Jul
    • Re: mysqldump loses auto_incrementAlexander Skwar17 Jul
      • Re: mysqldump loses auto_incrementPaul DuBois17 Jul
  • Re: mysqldump loses auto_incrementGerald R. Jensen18 Jul