MySQL Error 1366

--0-929746520-1180385411=:87087
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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','D FGDFGF','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.
--0-929746520-1180385411=:87087--

Re: MySQL Error 1366

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

LOAD DATA INFILE imports a CSV like file, it can't contain create table
statements or insert statements.

See the documentation: http://dev.mysql.com/doc/refman/4.1/en/load-data.html


If you have a script with create table & insert statements, use source:

source (\.) Execute a SQL script file. Takes a file name as an argument.

So

\. filename

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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#a10846 547
Sent from the Php - Database mailing list archive at Nabble.com.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php