pv + gzip + mysql
Posted on Tuesday, May 12, 2009
I am writing this down for my own benefit:
Dumping with on-the-fly gzip and speed indicator.
$ mysqldump -u root -p database | pv | gzip -c > database.sql.gz
Loading with on-the-fly gunzip and speed indicator.
$ pv database.sql.gz | gunzip | mysql -u root -p database