SQL Import not working after export -
No matter if I use revision 1691 or the newest 2374 of HeidiSQL both to export/dump a table and afterwards tries to import/load it again using HeidiSQL it gives the error shown on the picture.
ERROR:
You have an error in your SQL syntax - check the manual - right syntax to use near xxx WRITE at line 1.
I use 5.0.45 community version of MySQL Server.
And I have checked the manual 5.0 should support the line LOCK TABLES...
---- snap from my SQL file created by HeidiSQL ---
#
# Dumping data for table 'lytter_genrer'
#
LOCK TABLES "lytter_genrer" WRITE;
/*!40000 ALTER TABLE "lytter_genrer" DISABLE KEYS;*/
REPLACE INTO "lytter_genrer" ("pID", "gID", "cID") VALUES
(760,1,0);
------------------------------------------------------------
What is wrong?
Why is it not possible to export AND import in the excact same version of HeidiSQL?
What should I do in order to be able to import again?
The error "xxx" was...:
Error.
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax near '"my_table" WRITE' at line 1.
But I mean. the whole SQL-file is MADE by HeidiSQL's export function, so why can it not IMPORT it again?
Error.
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax near '"my_table" WRITE' at line 1.
But I mean. the whole SQL-file is MADE by HeidiSQL's export function, so why can it not IMPORT it again?
Please login to leave a reply, or register at first.