Hi,
I wonder if we should stop to offer the MYSQL40 mode in export, or at
the very least display a big warning about it. In this mode, MySQL
creates a dump that removes the auto_increment clause for the primary key!
Marc
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 358345 to server version: 5.0.21-standard
mysql> show create table bug1607282;
CREATE TABLE `bug1607282` (
`id` int(11) NOT NULL auto_increment,
`description` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
mysql> set sql_mode=MYSQL40;
mysql> show create table bug1607282;
CREATE TABLE `bug1607282` (
`id` int(11) NOT NULL,
`description` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM