Check the progress of Data Import/Restore MySQL in Windows

Question

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?

Solution 1

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

Solution 2

This has been an issue for Mac since 2014 and has affected me today using Ubuntu 17.10.

So disregard this screen, it is useless.

You're thinking along the right lines with processlist.

Execute the following command to show running processes:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST

If your import is still running, you will expect to see at least one row (process) with a STATE of update, COMMAND of query, and the INFO column will list the SQL query currently being executed by that process.