distal-attribute
distal-attribute
distal-attribute
distal-attribute

SQL Error (1064) using mysql server community 5.6.10 and heidisql 7.0

ikolak78 posted 2 years ago in Import/Export
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
jfalch posted 2 years ago
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 ?
ikolak78 posted 2 years ago
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'
#
jfalch posted 2 years ago
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).
ikolak78 posted 2 years ago
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;

jfalch posted 2 years ago
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.
ikolak78 posted 2 years ago
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.