Skip to content

Instantly share code, notes, and snippets.

@christopher-paul-shaw

christopher-paul-shaw/mysqldump-progress-export

Last active November 29, 2022 09:00
Show Gist options
  • Save christopher-paul-shaw/db73591eb749949aad126947f1122702 to your computer and use it in GitHub Desktop.
Save christopher-paul-shaw/db73591eb749949aad126947f1122702 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Dump With Progress Bar
Raw
mysqldump-progress-export
Exporting From DB
mysqldump -u root -ppassword databasename | pv --progress --size 10g -t -e -r -a > databasedump.sql
Importing
pv sqlfile.sql | mysql -uxxx -pxxxx dbname
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment