The file is in a world readable directory tree. Shouldn't the LOCAL qualifier make mysql read the file from the client running and not the host?
I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql FRM file that is in the databases directory on the Mysql host. The server found the file even though I specified local. Don't know if that means anything or not, or if that is normal mysql behavior. exp; load data local infile 'table.frm' replace into table testtable Shouldn't mysql be looking for table.frm on my client machine and not the 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: > > 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 technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php