#1357 (in 2.6.0) Cannot change auto_increment of InnoDB

[Ryan Carsten Schmidt]

In the Operations tab, phpMyAdmin offers the ability to set the
auto_increment value. This works for MyISAM tables, but not for
InnoDB.

phpMyAdmin should either not show this option for InnoDB tables,
or should offer a workaround, such as inserting a row with an ID
one less than the specified next value, and then deleting it again,
but note this:

http://dev.mysql.com/doc/mysql/en/InnoDB_auto-
increment_column.html

It says that the autoincrement value will reset itself when the
server is restarted. So, if the above workaround is chosen, the
user maybe should at least be informed that their change may get
undone if the server is restarted.

Tested in PMA 2.5.7-pl1 and 2.6.0 CVS snapshot 20040803-041652.

[Marc Delisle]

Logged In: YES
user_id=210714

Now display table options, according to table type.