As many people know, some bugs in MySQL do not close for years. But still open bug # 20786 “mysqldump always includes AUTO_INCREMENT” was luckier than the others - at least he received a real birthday cake for his 7th birthday!
')
Bug description
[29 Jun 2006 22:31] Erik Kay
I've run into a change between 5.1.9 and 5.1.11 that's causing me problems. mysqldump now includes AUTO_INCREMENT = xxx in the table definition, even when you specify --no-data. CREATE TABLE, which I assume mysqldump is using under the covers.
It would be a little bit more than a little bit. for development purposes.