• June 21, 2006

  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. :)

  • By seven in developers journal
  • 6,968 views
  • 1 Comments

Reader comments:

1.  

   March 28, 2009 @ 23:36

   RaiulBaztepo says:

   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