Jun
21
Mysqldump doesn’t like auto_increment
Posted by seven
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=latin1' from sql file. If you are lucky it will work. 
March 28th, 2009 at 23:36
Hello!
Very Interesting post! Thank you for such interesting resource!
PS: Sorry for my bad english, I’v just started to learn this language
See you!
Your, Raiul Baztepo