$ mysqldump -u [username ] -p [dbname] | pv | gzip -9 > [dbdump.sql.gz]
$ pv dbdump.sql.gz | gunzip | mysql -h hostname -uusername -p dbname
$ mysqldump -u [username ] -p [dbname] | pv | gzip -9 > [dbdump.sql.gz]
$ pv dbdump.sql.gz | gunzip | mysql -h hostname -uusername -p dbname