Re: Re: problem with load data local infile

2002-04-21 Thread Paul DuBois
At 23:34 -0500 4/20/02, Darren Vollmer wrote: > > >Both files are world readable. >> >> How do you know this? > >Because FTP tells me they are. > >> >> Also, when you say "client machine", what do you mean? In particular, >> are the web server and the MySQL servers running on the same machine

Re: Re: problem with load data local infile

2002-04-20 Thread Darren Vollmer
> >Both files are world readable. > > How do you know this? Because FTP tells me they are. > > Also, when you say "client machine", what do you mean? In particular, > are the web server and the MySQL servers running on the same machine? > Client machine is the machine running the webserver and

Re: Re: problem with load data local infile

2002-04-20 Thread Fiasco
get a different error message then can't get stat of 'filename' (Errcode 2)? Thanks for your help and patience Darren - Original Message - From: "Fiasco" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 7:36 PM

Fw: Re: problem with load data local infile

2002-04-20 Thread Fiasco
- Original Message - From: "Fiasco" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 7:28 PM Subject: Re: Re: problem with load data local infile > > > > >The error I receive is: > > >Can&

Fw: Re: problem with load data local infile

2002-04-20 Thread Fiasco
- Original Message - From: "Fiasco" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 6:28 PM Subject: Re: Re: problem with load data local infile > The error I receive is: > Can't stat file 'filena

Re: Re: problem with load data local infile

2002-04-20 Thread Paul DuBois
Message - >From: "Victoria Reznichenko" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, April 20, 2002 6:14 AM >Subject: Re: Re: problem with load data local infile > > >> Darren, >> Saturday, April 20, 2002, 1:23:54 PM, you wrote: >

Re: Re: Re: problem with load data local infile

2002-04-20 Thread Victoria Reznichenko
Darren, Saturday, April 20, 2002, 2:34:06 PM, you wrote: DV> The file is in a world readable directory tree. DV> Shouldn't the LOCAL qualifier make mysql read the file from the client DV> running and not the host? DV> I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql

Re: Re: problem with load data local infile

2002-04-20 Thread Darren Vollmer
server? - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 6:14 AM Subject: Re: Re: problem with load data local infile > Darren, > Saturday, April 20, 2002, 1:23:54 PM, you wrote: >

Re: Re: problem with load data local infile

2002-04-20 Thread Victoria Reznichenko
Darren, Saturday, April 20, 2002, 1:23:54 PM, you wrote: DV> The file does exist. The file and its directory are 0777 permission. Such permissions are setting on all dirs, that contain path to your dir? Don't forget that you should have permissions to go through dirs ... DV> Darren -- For

Re: problem with load data local infile

2002-04-20 Thread Darren Vollmer
The file does exist. The file and its directory are 0777 permission. Darren - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 4:32 AM Subject: Re: problem with load data local infile >

Re: problem with load data local infile

2002-04-20 Thread Victoria Reznichenko
Darren, Friday, April 19, 2002, 3:33:50 PM, you wrote: DV> I am having problems with load data local infile. DV> The mysql host server is running 3.23.23 DV> I was able to successfully use load data local infile before to import data DV> off of a client machine onto the mysql host but now all i

Fw: problem with load data local infile (repeat)

2002-04-19 Thread Darren Vollmer
I never saw this message make this list so I'm reposting it. - Original Message - From: "Darren Vollmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 7:33 AM Subject: problem with load data local infile > I am having proble

problem with load data local infile

2002-04-19 Thread Darren Vollmer
I am having problems with load data local infile. The mysql host server is running 3.23.23 I was able to successfully use load data local infile before to import data off of a client machine onto the mysql host but now all i get is a can't stat file errcode2 message. I know that the pathname I