Import large MySQL database with progress bar

Contact us

Import large MySQL database with progress bar

PV can report progress for large MySQL database imports. First, download PV (http://linux.die.net/man/1/pv)

sudo apt-get install pv

To use PV, pass the dump file, then pipe the mysql command specifying the database with -D flag:

pv DUMP.mysql | mysql -u USER -p -D DATABASE_NAME

15 January 2019