Import DB with progress bar

pv sqlfile.sql | mysql -uxxx -pxxxx dbname
pv sqlfile.sql.gz | gunzip | sudo mysql dnname
mysqldump -hxxx -uxxx -p dbname | pv -W > dump.sqlmysqldump -hxxx -uxxx -p dbname | pv -W > dump.sql
cat dbdump.gz | gzip -d | mysql --password=root -v | time dd of=/dev/null status=progress

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.