Category: developers journal

Mysqldump doesn’t like auto_increment

Author: seven June 21, 2006

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

Author
seven
CEO/CTO at Nivas®
Neven Jacmenović has been passionately involved with computers since late 80s, the age of Atari and Commodore Amiga. As one of internet industry pioneers in Croatia, since 90s, he has been involved in making of many award winning, innovative and successful online project. He is experienced full stack web developer, analyst and system engineer. In his spare time, Neven is transforming retro-futuristic passion into various golang, Adobe Flash and JavaScript/WebGL projects.

    One thought on “Mysqldump doesn’t like auto_increment”

  • 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

  • Leave a Reply

    Your email address will not be published. Required fields are marked *