Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save anatoliyfedorenko/836704a2bf0cc7eb642f3a62562c545c to your computer and use it in GitHub Desktop.
Save anatoliyfedorenko/836704a2bf0cc7eb642f3a62562c545c to your computer and use it in GitHub Desktop.
Create db dump with all id primary keys NULL
mysqldump --complete-insert --host=localhost --user=root --password=root --no-create-info database | sed -e "s/([0-9]*,/(NULL,/gi" > database.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment