How to monitor progress of Linux commands using PV and Progress utilities
pv dump-`date -I`.sql | mysql -u root -pmagento -h 127.0.0.1 magento