Skip to content

Instantly share code, notes, and snippets.

@shoaibali

shoaibali/gist:e89998a01439c6fe1bc02e8a52ec7f11

Created May 1, 2016 05:19
Show Gist options
  • Save shoaibali/e89998a01439c6fe1bc02e8a52ec7f11 to your computer and use it in GitHub Desktop.
Save shoaibali/e89998a01439c6fe1bc02e8a52ec7f11 to your computer and use it in GitHub Desktop.
Download ZIP
how to see progress of mysql import gzip
Raw
gistfile1.txt
zcat filename.sql.gz | pv --progress --size `gzip -l filename.sql.gz | sed -n 2p | awk '{print $2}'` --name ' Importing.. ' | mysql -uroot databasename
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment