MySQL Error 1366

From: Date: Mon, 28 May 2007 20:50:11 +0000
Subject: MySQL Error 1366
Groups: php.db 
Request: Send a blank email to php-db+get-43648@lists.php.net to get a copy of this message
Hi All, I want to load data from dump file to MySQL table using LOAD DATA INFILE but there is Error 1366 : mysql> LOAD DATA -> INFILE 'D:/SITE/SOMETABLE.SQL' -> INTO TABLE SOMETABLE -> FIELDS TERMINATED BY ',' -> OPTIONALLY ENCLOSED BY '' -> LINES TERMINATED BY ')'; ERROR 1366 (HY000): Incorrect integer value: '--MySQL dump 10.10 -- --S' for column 'ID' at row 1 this is the header of my dump file: DROP TABLE IF EXISTS sometable; CREATE TABLE sometableo ( ID smallint(6) NOT NULL auto_increment, Name varchar(30) NOT NULL, title tinytext, description tinytext, cat tinytext, PRIMARY KEY (ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; LOCK TABLES sometable WRITE; /*!40000 ALTER TABLE sometable DISABLE KEYS */; INSERT INTO sometable VALUES (79,'110_1099','AAA','AAAAAA','AAA'),(80,'110_1100','AAA','DFGDFGF','AAA'), any idea for solving the problem? --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

« previous php.db (#43648) next »