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
SQL Error (1064) using mysql server community 5.6.10 and heidisql 7.0
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'
#
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'
#
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;
# 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;
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;*/
#
# 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.