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?