Importing SQL file to HeidiSQL

mysql heidisql
Dhanasekaran picture Dhanasekaran · Jul 6, 2015 · Viewed 10.4k times · Source

When I try to import the table and datas to HeidiSQL, I am getting two kind of errors.

  1. When Load SQL file and select "Run files(s) directly", the following popup displays and could not be closed

enter image description here

  1. When Load SQL file and select "Load file(s) into editor", the following error is being displayed.

enter image description here

Can anyone guide me how to resolve this?

Answer

Anse picture Anse · Jul 6, 2015

The same file must not be opened in another application, otherwise HeidiSQL is not able to apply a file lock here, which results in the above "Stream read error" message. So, make sure the file is not in use by some other application.

Also, file size can matter. On a 32bit Windows there is a chance you get the same error with files with some gb of text in them. The 64bit version of HeidiSQL can solve these issues.

Ah, and if you chose Encoding: "Auto detect" in the file-open-dialog, HeidiSQL may have failed during that auto-detection. Try to select the file-encoding manually.

Related questions

mysql Foreign key constraint is incorrectly formed error

I have two tables, table1 is the parent table with a column ID and table2 with a column IDFromTable1 (not the actual name) when I put a FK on IDFromTable1 to ID in table1 I get the error Foreign key …

Read More
Database Import error after exporting

Just like title say. I am using HeidiSQL, and i wan't to duplicate a database so i export the database, create a new empty with name "test". Then i change the name of the database to "test" in the .sql …

Read More
How to copy a database using HeidiSQL?

I have a local installation of MariaDB on a Windows XP. I created an empty database db_y which I wanted to populate with the tables of the database db_x which I exported as a dump-file from a MySQL-instance (…

Read More