List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 17 2001 9:59pm
Subject:Re: mysqldump loses auto_increment
View as plain text  
At 11:03 PM +0200 7/17/01, Alexander Skwar wrote:
>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.

Yeah, doing that is asking for trouble.  So is setting AI column values
to negative numbers.

>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

Paul DuBois, paul@stripped
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