tinker1987/mysql_import_progress

Created April 6, 2017 09:54

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

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

Download ZIP

It will show you a progress bar during the import progress based on the IO throughput.

Raw

mysql_import_progress

`pv -i 1 -p -t -e /path/to/sql/dump | mysql -u USERNAME -p DATABASE_NAME`

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