SQL: monitor mysql dump import

Pipe Viewer allows monitoring of large sql dump imports….

# Install...
sudo apt install pv

# Pipe the import..
pv <databse_dump_file_name> | mysql -u <username> -p <database_name>

# Also good to monitor the error log
sudo tail -f /var/log/mysql/error.log

"You want a toe? I can get you a toe. There are ways, Dude. You don't wanna know about it, believe me."