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

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