From: Ann W. Harrison
Date: July 28 2009 3:25pm
Subject: Re: Restore locking: TRUNCATE resets AUTO_INCREMENT on InnoDB
List-Archive: http://lists.mysql.com/backup/15
Message-Id: <4A6F187B.8060505@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=UTF-8
Content-Transfer-Encoding: 8BIT

> Susanne Ebrecht, 28.07.2009 06:34:
> 
> ...
>> According to my researches here I would recommend that we avoid to reset
>> AUTO_INC during TRUNCATE. Users won't expect such a behaviour.
>> Especially not, when they used SERIAL. The only way to change/reset
>> AUTO_INC should be via ALTER.
> 

Ingo Strüwing wrote:

> Thank you very much for your analyze. I suggest you to file a bug report
> against TRUNCATE.
> 

Having nothing to do with the backup problem per se:

Falcon bug 22173 says that truncate should reset the autoincrement
counter, which Falcon now does.


Cheers,


Ann