From: Daevid Vincent
Date: March 29 2005 9:28pm
Subject: mysqldump and missing AUTO_INCREMENT=1000 ??
List-Archive: http://lists.mysql.com/mysql/181852
Message-Id: <200503292127.j2TLR2Y1012237@daevid.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

I have a table that I created by hand like this:

DROP TABLE IF EXISTS testset;
CREATE TABLE testset (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  special enum('','all','safe','unsafe') NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) TYPE=MyISAM AUTO_INCREMENT=1000;

When I do a mysqldump (version 4.0.18), I want the "AUTO_INCREMENT=1000"
part to be retained.  Sadly, it is stripped off?!

I don't see a command line option for mysqldump to do that though?
http://dev.mysql.com/doc/mysql/en/mysqldump.html

I cannot update the mySQL server version.