Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Thomas has posted 33 posts at DZone. View Full User Profile

Exclude AUTO_INCREMENT Value From A MySQL Dump

01.12.2011
| 3024 views |
  • submit to reddit 
        
mysqldump -d my_database | sed 's/AUTO_INCREMENT=[0-9]*//' > my_database.dump


Reference:  http://forums.mysql.com/read.php?28,99332,206511#msg-206511
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers