Import the large sql its not usable

[expired user #9005]'s profile image [expired user #9005] posted 9 years ago in General Permalink
I've asp.net hosting hosted in asphostportal.com, and I would like to combine using HeidiSQL but I've problem after import the large sql its not usable.

The process is fairly easy to reproduce but mainly occurs if the SQL file needs to be loaded into memory:

1. Right-click in the query window and select "Load SQL File"
2. Select a large SQL file to import
3. A warning dialogue box appears as the file size is greater than 5MiB. Select "Yes"
4. Chunking occurs and the progress meter fills until complete and the import progress window disappears.
5. Clicking or trying to obtain focus on any element in HeidiSQL when the import is complete is unresponsive (OS plays sound that child window needs attention).

Need advise
ansgar's profile image ansgar posted 9 years ago Permalink
It is probably the case that the dialog is still active, but invisible. Or, if the file was very large, HeidiSQL needs a bit more time to clean up resources. However, I cannot reproduce that here on a MySQL server. You should probably post the details of your configuration (server type/version, HeidiSQL version, OS, etc.)

Please login to leave a reply, or register at first.