insytes/mysqldump-where

Last active December 10, 2018 00:01

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/insytes/103154f7738afdd4b736e22f6476fbdd.js"></script>
Save insytes/103154f7738afdd4b736e22f6476fbdd to your computer and use it in GitHub Desktop.

Download ZIP

mysqldump with complete inserts including column definitions and a WHERE clause

Raw

mysqldump-where

mysqldump -u root -p database table --no-create-info --skip-extended-insert --complete-insert --where="active = 1" > dump.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment