List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:March 29 2005 9:28pm
Subject:mysqldump and missing AUTO_INCREMENT=1000 ??
View as plain text  
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.

Thread
mysqldump and missing AUTO_INCREMENT=1000 ??Daevid Vincent29 Mar