mysqldump ignores auto_increment

[bagpuss]

Hi,
I got confused looking to see if this was a known problem - so thought I'd
try again.....

mysql_standard 4.1.16 on Linux...
Synopsis:
Create table with auto_increment
mysqldump database
output doesn't create table with auto_increment.

Example:
Create a table in a junk database using,

create table tbl ( id int(11) not null auto_increment, primary key(id));

Backup the database using,

mysqldump -u ... -p.... junk > out.sql

Look at out.sql, (snipped for brevity),

--
-- Table structure for table `tbl`
--

DROP TABLE IF EXISTS `tbl`;
CREATE TABLE `tbl` (
  `id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

wheres the auto_increment ???

Help!
Regards,
Ian.