Auto_increment

[ninevolt]

I am trying to load a 4.1 database into 5.x and having issues. I keep getting errors on a few queries on one table. The only difference I see between the versions is when I do SHOW CREATE TABLE table the two have different endings ..

The 4.1 that works fine has;
) ENGINE=MyISAM DEFAULT CHARSET=latin

5.x version that errors out has;
) ENGINE=MyISAM AUTO_INCREMENT=4141 DEFAULT CHARSET=latin1

I loaded the database doing a mysqldump on 4.1 and loading it on 5.x doing on mysql -u user -p db < file.sql

Why is 5.x addding AUTO_INCREMENT=4141 and how can I stop it?

[HarryR]

Use the --compatible option to output SQL compatible with older versions or other databases entirely.

For example:

mysqldump --compatible=mysql40

[ninevolt]

So if I want to dump a 4.1 database to migrate to 5.x I should use that command?

mysqldump --compatible=mysql40

[longneck]

if you're going up, then no options are needed.