I am importing a 7 GB foobar.sql to restore a table in a local database. $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5... How can I monitor the progress of an import of a large .sql file? EmailThis Premium lets you save unlimited bookmarks, PDF, DOCX files, PPTs and images. It also gives you a PDF copy of every page that you save. Upgrade to Premium → When you execute a mysqldump of a single database, all tables are dumped in alphabetical order. Naturally, the reload of the mysqldump into a database would also be in alphabetical order. You could just do a SHOW PROCESSLIST; and find out the DB Connection running the mysqldump. When the dump is reloaded, the DB Connection will vanish. If you want to know what tables are in the dumpfile, run this against foobar.sql cat foobar.sql | grep "^CREATE TABLE" | awk '{print $3}' UPDATE 2012-05-02 13:53 EDT Sorry for not noticing that there is only one table. If the table is MyISAM, the only way to monitor is from the OS point of view. The reason? The table is write-locked throughout the reload. What do you look for? The size of the .MYD and .MYI files. Of course, you need to compare that with what the table size was before on the other DB server you imported from. If the table is InnoDB and you have innodb_file_per_table enabled, the only way to monitor is from the OS point of view. The reason? The table is write-locked throughout the reload. What do you look for? The size of the .ibd file. Of course, you need to compare that with what the table size was before on the other DB server you imported from. If the table is InnoDB and you have innodb_file_per_table disabled, not even the OS point of view can help. UPDATE 2012-05-02 13:56 EDT I addressed something like this last year : How do I get % progress for "type db.sql | mysql" UPDATE 2012-05-02 14:09 EDT Since a standard mysqldump write-locks the table like this: LOCK TABLES `a` WRITE; /*!40000 ALTER TABLE `a` DISABLE KEYS */; INSERT INTO `a` VALUES (123),(451),(199),(0),(23); /*!40000 ALTER TABLE `a` ENABLE KEYS */; UNLOCK TABLES; then, there is no way to get a progress from with mysql until the table lock is released. If you can get LOCK TABLES and UNLOCK TABLES commented out of the dumpfile... if the table is MyISAM, SELECT COUNT(*) would work if the table is InnoDB, SELECT COUNT(*) would probably slow down/halt the load until count is done Source: https://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file Please check the attached file. EmailThis was not able to extract useful content from the website. Hence, we have saved the webpage to a PDF file. You can find that attached along with this email. Upgrade to Premium Plan ✔ Save unlimited bookmarks. ✔ Save PDFs, DOCX files, images and Excel sheets as email attachments. ✔ Get priority support and access to latest features. Upgrade to Premium EmailThis Send web pages & articles to your email inbox. If you have any suggestions, bug reports or comments, please let me know at bharani@hq.emailthis.me. You can also Tweet to us at @EmailThis_