After submitting Bug 125804, I modified the SQL I was trying to import. I changed the CREATE TABLE statement so that the column that was set to auto_increment would not. Then after the INSERT statements I included "alter table foo auto_increment = n", substituting the table name and the next value for foo and n. I then dumped my SQL back out to diff it against the SQL I put in. The alter table statements did not set the auto_increment -- they set a default value! CREATE TABLE users ( - id int(11) NOT NULL, + id int(11) NOT NULL default '0', ... CREATE TABLE templates ( - id int(11) NOT NULL, + id int(11) NOT NULL default '0', ... That's just broken. Version-Release number of selected component (if applicable): mysql-3.23.58-9
Fedora Core 2 is now maintained by the Fedora Legacy project for security updates only. If this problem is a security issue, please reopen and reassign to the Fedora Legacy product. If it is not a security issue and hasn't been resolved in the current FC3 updates or in the FC4 test release, reopen and change the version to match.
Closed per above message and lack of response. Note that FC2 is not even supported by Fedora Legacy currently.