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
| 4224 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