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

"How are you gonna keep ‘em down on the farm once they’ve seen Karl Hungus?"