Mysqldump doesn’t like auto_increment
Today I’we found out that mysqldump 4/5 has bogus bug, when you dump database with –compatible=mysql40, mysqldump forgets to add AUTO_INCREMENT value to create table query. It’s official bug. They released a patch for this on April 28.
If you don’t fancy patching, and you really need to dump your 4.1.20 database and import it to a 3.23 mysql server (can you believe that some web hosting providers are still using it??), you can allways call good old MySQL Front to the rescue. Export your db and remove ‘ENGINE=MyISAM DEFAULT CHARSET=utf8‘ from sql file. If you are lucky it will work. :)