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

[expired user #6824]'s profile image [expired user #6824] posted 11 years ago in Import/Export Permalink
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's profile image jfalch posted 11 years ago Permalink
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 ?
[expired user #6824]'s profile image [expired user #6824] posted 11 years ago Permalink
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's profile image jfalch posted 11 years ago Permalink
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).
[expired user #6824]'s profile image [expired user #6824] posted 11 years ago Permalink
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's profile image jfalch posted 11 years ago Permalink
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.
[expired user #6824]'s profile image [expired user #6824] posted 11 years ago Permalink
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.