Import mysql database with progress bar and log on error

imprort_db.sh

# import (with pv)
pv db_dump.sql | mysql -u <user> -p'<password>' <database> > error.log

# import (without pv)
mysql -u <user> -p'<password>' <database> < db_dump.sql > error.log

# export
mysqldump -u <user> -h <host> -p'<password>' <database> | pv > db_dump.sql

# export with progress
# ==================
# to get size you should run:
# > SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;
# ==================
mysqldump -u <user> -h <host> -p<password> <database> | pv --size 100m > db_dump.sql

Hi @probil and thanks for your useful gist.
Do you know if is it possible to run "pv" omitting the password from the command line? For security reason, I prefer to digit the password out of the command line.
I hope to be clear :)

Many thanks!
Davide
Italy

Hi @danjde
Just add empty -p param and it will ask you password in the terminal

# asks for password in command line
mysqldump -u <user> -h <host> -p <database> | pv > db_dump.sql

Ah, well!
Thanks for your help, very appreciates ;-)