Monitor progress of sql file import

Install and use pipe viewer:

apt-get install pv
pv upload/file.sql | mysql -u root -p DBName
Enter password:
2.58MiB 0:00:16 [77.9KiB/s] [====================================================================================================================>                                            ] 73% ETA 0:00:05

You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.