MySQL Bugs: #54370: import is running ... no status bar, no statistics

Bug #54370	import is running ... no status bar, no statistics
Submitted:	9 Jun 2010 14:38	Modified:	9 Jun 2010 16:19
Reporter:	tony cleveland	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.22 OSS RC	OS:	Windows (XP SP3)
Assigned to:		CPU Architecture:	Any
Tags:	import is running

Description:
Import from self-contained file
Click Start Import
As the import is being perfomed the progress bar never increments or shows any progress.  When the import is finally completed then the progress bar shows 100%.

How to repeat:
Import a self-contained file

Thank you for the bug report.

I had this issue today.  I waited a half an hour, status still said "starting" and the progress bar did not change, so I tried something different and same thing. Maybe instead of "status: starting" you could say "status: this status bar does not work" because otherwise it makes you think you're crazy. :)  Thanks!

Yes, this also happens to me, I'm trying to import approx 20GB of sql data and structure. 

I though it is not working, but when I stopped the Import and refresh my schemas, I saw the db which I am trying to import but with incomplete tables and data.

It's just annoying to observe that nothing is happening and presume it is not working.

Also true on Linux Ubuntu

Also true on every version of Mac OS since at least 2014.

Any updates on getting it fixed?

any updates?

any updates?

User feedback is no minor issue. 

Yes, we computer people have other means to check whether it's running, but regular users can struggle with this.

Any updates on this? It's frustrating to face this bug every time.

I have a 96 gb file to import and am unsure about how to track and how long it may take with this bug ongoing. Is there no way at all to check the progress? Log files at least?

This is still happening. To see the progress, you can switch to a query window and do "SELECT count(*) FROM <yourtable>". There is also a "Show Log" button where you can see a slew of lines like "Data import". I have a 45MB file with a few hundred thousand lines to import and it's taken 10 minutes to load about 500 lines, so I will let it run overnight. I have no idea how @Kajal is going to load 96GB..!

I switched to LOAD DATA INFILE which is literally thousands of time faster (8 seconds to load the 45MB file).