RE: Problem in using LOAD DATA LOCAL INFILE

2006-06-01 Thread Neeraj
text file.. Can you help Cheers ………:-) Neeraj Black Bits _ From: Harish TM [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 9:54 PM To: sheeri kritzer Cc: Neeraj; mysql@lists.mysql.com Subject: Re: Problem in using LOAD DATA LOCAL INFILE You need to check your

RE: Problem in using LOAD DATA LOCAL INFILE

2006-05-31 Thread Neeraj
: Neeraj; mysql@lists.mysql.com Subject: Re: Problem in using LOAD DATA LOCAL INFILE 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

Re: Problem in using LOAD DATA LOCAL INFILE

2006-05-31 Thread sheeri kritzer
only and getting error line now data for other columns Hope you will find the solution Cheers.:) Neeraj Black Bits -Original Message- From: Harish TM [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 10:23 PM To: sheeri kritzer Cc: Neeraj; mysql@lists.mysql.com Subject: Re: Problem

Re: Problem in using LOAD DATA LOCAL INFILE

2006-05-31 Thread Harish TM
@lists.mysql.com Subject: Re: Problem in using LOAD DATA LOCAL INFILE 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

Re: Problem in using LOAD DATA LOCAL INFILE

2006-05-30 Thread sheeri kritzer
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 )

Re: problem with the load data

2003-02-11 Thread Stefan Hinz
Edgard, I'm trying to load a text file, I've extract from access, and Ihave the following error mysql LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores - FIELDS TERMINATED BY '|' ENCLOSED BY ''; ERROR 13: Can't get stat of '/home/dapasedg/provedores.txt' (Errcode:

re: problem with the load data

2003-02-11 Thread Egor Egorov
On Tuesday 11 February 2003 18:13, Edgard Dapás wrote: I'm trying to load a text file, I've extract from access, and Ihave the following error mysql LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores - FIELDS TERMINATED BY '|' ENCLOSED BY ''; ERROR 13: Can't get stat of

Re: Problem dealing with load data

2002-07-12 Thread Egor Egorov
Sofiane, Friday, July 12, 2002, 2:07:00 PM, you wrote: SF hello everybody SF I have a problem using mysql and the load data infile command. i have all my SF data in a text file tabulated and using load data as it is documented i SF receive this message SF ERROR 13: Can't get stat of

Re: Problem dealing with load data

2002-07-12 Thread Gerald Clark
The server must be able to read the file, and since the server normally runs as the user 'mysql', it will not be able to read files sitting in root's home directory. Put the file in /tmp, and make it readable by others. Sofiane FAESSEL wrote: hello everybody I have a problem using mysql and