pv {source_database.sql} | mysql -u{user} -p {destination_database}

source https://major.io/2010/11/24/monitor-mysql-restore-progress-with-pv/