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? Client

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

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 Darren, Friday, April 19, 2002

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: 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 DV

Re: Re: problem with load data local infile

2002-04-20 Thread Paul DuBois
Subject: Re: Re: problem with load data local infile 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

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 'filename' (errcode 2) I noticed what you mentioned about

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't stat file 'filename' (errcode 2) It can't stat *filename*? Don't

Re: Re: problem with load data local infile

2002-04-20 Thread Fiasco
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 Subject: Fw: Re: problem with load data local infile - Original

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 MySQL