The conventional workaround: $ mysqldump -d my_database | sed 's/ AUTO_INCREMENT... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

CoffeeOnWrite on June 28, 2013 | parent | context | favorite | on: An open MySQL bug receives a real Birthday cake

The conventional workaround:

  $ mysqldump -d my_database | sed 's/ AUTO_INCREMENT=[0-9]*\b//' > dump.sql

shdon on June 28, 2013 [–]

That's also listed in the comments for the bug, as well as some (contrived) examples as to when it wouldn't work. Surprising it hasn't been fixed, considering how simple the true fix is.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact