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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
