SQL Error (1064) using mysql server community 5.6.10 and heidisql 7.0
| User, date | Message |
|---|---|
|
Written by ikolak78
3 months ago Category: Import/Export 4 posts since Sat, 23 Feb 13 |
Hey in need of some help! I've been having trouble loading my data back to heidisql, after updating the server and heidsql. this is my error! SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"table" ENABLE KEYS;*/UNLOCK TABLES' at line 1. # HeidiSQL Dump # # -------------------------------------------------------- # Host: 127.0.0.1 # Database: dbsomething # Server version: 5.1.30-community # Server OS: Win32 # Target compatibility: ANSI SQL # HeidiSQL version: 4.0 # Date/time: 2009-09-30 22:31:02 # -------------------------------------------------------- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/ /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/ need help |
|
Written by jfalch
3 months ago 223 posts since Sat, 17 Oct 09 |
a) please show the line containing the text mentioned in the error message("table" ENABLE KEYS;*/UNLOCK TABLE), preferably with some lines before and after it. b) why does the dump show heidisql v4.0 and a date more than three years in the past ? |
|
Written by ikolak78
3 months ago 4 posts since Sat, 23 Feb 13 |
Hope this helps.. it shows heidisql v4.0 because, after updating I lost what I had before therefore, took the old data I had. I have done this before, and everything worked fine. hope that someone can help me.. thanks.. # HeidiSQL Dump # # -------------------------------------------------------- # Host: 127.0.0.1 # Database: database # Server version: 5.1.30-community # Server OS: Win32 # Target compatibility: ANSI SQL # HeidiSQL version: 4.0 # Date/time: 2009-09-30 22:33:02 # -------------------------------------------------------- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/ /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/ # # Database structure for database 'database' # CREATE DATABASE /*!32312 IF NOT EXISTS*/ "database" /*!40100 DEFAULT CHARACTER SET latin1 */; USE "database"; # # Table structure for table 'table' # |
|
Written by jfalch
3 months ago 223 posts since Sat, 17 Oct 09 |
please show the line containing the text mentioned in the error message("table" ENABLE KEYS;*/UNLOCK TABLE), preferably with some lines before and after it. do not simply show the start of the file. show the part that contains the above-mentioned text (ENABLE KEYS etc). |
|
Written by ikolak78
3 months ago 4 posts since Sat, 23 Feb 13 |
her is the table with the error at line 1 # Table structure for table 'table' # CREATE TABLE /*!32312 IF NOT EXISTS*/ "table" ( "field" tinyint(3) unsigned NOT NULL AUTO_INCREMENT, "field" varchar(50) DEFAULT NULL, "field" varchar(50) DEFAULT NULL, "field" varchar(50) DEFAULT NULL, "field" varchar(11) NOT NULL, "field" mediumtext, "field" tinyint(3) unsigned DEFAULT NULL, "field" varchar(50) DEFAULT NULL, PRIMARY KEY ("fieldID") ) AUTO_INCREMENT=8; |
|
Written by jfalch
3 months ago 223 posts since Sat, 17 Oct 09 |
I do not want to see the table, either. I want to see a line in this sql file that contains the text "table" ENABLE KEYS;*/UNLOCK TABLE plus some 2 or 3 lines before and after it. |
|
Written by ikolak78
3 months ago 4 posts since Sat, 23 Feb 13 |
sorry for the mix up.. does this help # # Dumping data for table 'table' # LOCK TABLES "table" WRITE; /*!40000 ALTER TABLE "table" DISABLE KEYS;*/ REPLACE INTO "table" ("field", "field", "field", "field", "field", "field", "field", "field") VALUES (2,'CVnuB','Jøren svensen','p@ha.com','12321233','så er der måske noget til dig her ',NULL,'12:12'); REPLACE INTO "table" ("field", "field", "field", "field", "field", "field", "field", "field") VALUES (3,'MedWeb','Sanne hansen','he@sov.dk','23405920','dfdfew wf rerevgrev',NULL,'12:12'); REPLACE INTO "table" ("field", "field", "field", "field", "field", "field", "field", "field") VALUES (4,'Se.com','Sune Hansen','SE@2.dem','40 50 5556','så sker der noget måske',NULL,'13:19'); REPLACE INTO "table" ("field", "field", "field", "field", "field", "field", "field", "field") VALUES (5,'','','','','',0,''); REPLACE INTO "table" ("field", "field", "field", "field", "field", "field", "field", "field") VALUES (6,'WEBus.com','kaloki','Peter@mig.ja','','',0,''); REPLACE INTO "table" ("field", "field", "field", "field", "field", "field", "field", "field") VALUES (7,'','','','','',0,''); /*!40000 ALTER TABLE "table" ENABLE KEYS;*/ UNLOCK TABLES; /*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/ /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/ |
|
Please login to leave a reply, or register at first. |