Check the progress of Data Import/Restore MySQL in Windows

mysql database mysql-workbench progress mysqlimport
Harsh Singh picture Harsh Singh · Dec 14, 2016 · Viewed 8.6k times · Source

I am new to MySQL. I have a decent machine and have been importing a 16gb .sql database since yesterday. The progress bar doesn't show anything but it does say Import is running.... I have searched everywhere and there is no clear solution to know the progress of the import process in Windows.

I have tried:

SHOW PROCESSLIST

and 

SHOW DATABASES

but it doesnt help me indicate an ETA or I don't know what im looking at.

I am running on MySQL workbench 6.3.7. Will you guys be able to help me?

Answer

Ithar picture Ithar · Jul 25, 2017

I have also been looking for something to tell me the progress of my import.
Assuming that you are using MySQL Workbench then unfortunately the import status seems to not show anything if you tried to import via Server > Data Import. The only suggestion I would give is to monitor the status from Server > Status; there you can see CPU usage plus other info.

Also depending on your dump you can try File > Run SQL Script ... this will give a progress bar.

My Env

OS: Windows 10

RAM: 16GB

MySQL: 5.7.10

Related questions

Authentication plugin 'caching_sha2_password' cannot be loaded

I am connecting MySQL - 8.0 with MySQL Workbench and getting the below error: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found I have tried with other client …

Read More
Can't connect to MySQL server on '127.0.0.1' (10061) (2003)

I know this question was asked a lot before but I tried some of the solutions which were given and nothing worked.. I have downloaded MySQL Workbench 6.1 on my windows 7 x64 and now as I want to start and do …

Read More
Error Code: 2013. Lost connection to MySQL server during query

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away …

Read More