At 6:34 -0500 4/20/02, Darren Vollmer wrote: >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?
LOCAL requires only that you be able to read the file. With the LOCAL keyword, the program on the client machine reads the file and sends it to the server to be inserted into the table. The MySQL server takes those records, and it's what accesses the table.frm file. How could the client access table.frm? That file isn't even on the client host necessarily. Something that might account for the difficulty, if you've upgraded MySQL recently: A change was made in MySQL 3.23.49 that causes LOCAL to be disabled (by default?). You may be able to re-enable it by invoking mysql with the --local-infile option. Try mysql --help to see if that option is listed in the help message. By the way, what was the error message you got? > > >----- 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 --------------------------------------------------------------------- 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
