Re: MySQL Error 1366

Chetanji says, This may be a typo of yours. Look at the header... CREATE TABLE sometableo The 'o' is added by mistake? Blessings, Chetanji elk dolk wrote: > >>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. >> -- View this message in context: http://www.nabble.com/MySQL-Error-1366-tf3830472.html#a10846547 Sent from the Php - Database mailing list archive at Nabble.com.