Bug#364703: phpmyadmin: SQL table sructure dump does not include auto_increment

[Thijs Kinkhorst]

Hello Viktor,

> Create a table with the following fields:
> 
> id INT(11) auto_increment PRIMARY KEY
> value VARCHAR(200)
> 
> Create two records. The next auto_increment id value should be: 3
> 
> Dump this table (structure and data) using MySQLAdmin. The next auto 
> increment 
> value (3) will not be included in the CREATE statement.

I cannot reproduce this bug with latest phpMyAdmin in unstable and with
MySQL 4.0 as included in sarge. When exporting a table that has an
auto-increment column, I get this:

        CREATE TABLE `test` (
                [...]
          PRIMARY KEY  (`id`)
        ) TYPE=MyISAM AUTO_INCREMENT=19 ;

It works just like expected. Can you confirm that the problem still
exists, or give me more informtion on the circumstances to reproduce?


Thanks,
Thijs

signature.asc
Description: This is a digitally signed message part