Importing Big mysqldump with Progress Bar PV


I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place:
$ rpm -Uhv
Install pv using yum:
$ yum install -y pv
Installation done. Let the importing begin!
$ pv /home/user/my_big_dump.sql | mysql -uroot -p
For Ubuntu/Debian distribution intall PV using-
apt-get install pv

Leave a Reply