I went through a lot of trouble with Load data local infile... There are a lot of things regarding Local that MySql does not allow due to security reasons. As mentioned before this you could give us the error... that might help
alternatively try out mysqlimport http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html Its similar but a lot easier to use. However its a program so embedding it in code is not efficient.. hope this helps harish On 5/30/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
What's the error you are getting? What MySQL version are you using? On 5/26/06, Neeraj <[EMAIL PROTECTED]> wrote: > Hi all > > > > I have a table with following structure > > > > CREATE TABLE `dsc` ( > > `ch_code` varchar(255) default NULL, > > `name` varchar(255) default NULL, > > `inof` blob > > ) ENGINE=InnoDB DEFAULT CHARSET=latin1; > > > > And I have give a text file with following format > > > > Ü > > ¢ > > Ch.Code :02Ü > > MEATÜ > > > > 1 COUNTRY : JORDAN > > > 2 COUNTRY : SAUDI ARABIA > > > > > > Ü > > ¢ > > Ch.Code :03Ü > > FISHÜ > > > > 1 COUNTRY : JORDAN > > > > > Ü > > ¢ > > Ch.Code :04Ü > > FISHÜ > > > > 1 COUNTRY : JORDAN > > > 2 COUNTRY : SAUDI ARABIA > > > > ... > > > > I am trying to import the text file into table. I have tried various ways > but unable to find the solution. the code I am trying to import the file is > as follows > > > > LOAD DATA LOCAL INFILE 'd:\\data3.txt' INTO TABLE dsc FIELDS TERMINATED BY > 'Ü\n' LINES TERMINATED BY '¢\n' (ch_code, name, info); > > > > Can any one help me in loading this file… > > > > Regards > > > > Neeraj Black Bits > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
