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

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

User, date Message
Written by ikolak78
1 year 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 jfalchMoney, Euro
1 year ago
352 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
1 year 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 jfalchMoney, Euro
1 year ago
352 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
1 year 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 jfalchMoney, Euro
1 year ago
352 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
1 year 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.