Skip to content

Instantly share code, notes, and snippets.

@jrickerd

jrickerd/gist:2852383

Created June 1, 2012 14:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jrickerd/2852383 to your computer and use it in GitHub Desktop.
Save jrickerd/2852383 to your computer and use it in GitHub Desktop.
Download ZIP
Strip autoincrement from dump
Raw
gistfile1.sql
mysqldump -u root -d -R --single-transaction <db> | sed 's/ AUTO_INCREMENT=[0-9]*\b//' | gzip > out.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment