View Single Post

  #9 (permalink)  
Old 01-04-2008
Kees Nuyt
 
Posts: n/a
Default Re: can't read file into a table

On Wed, 2 Jan 2008 18:39:15 -0500, "don" <don@panix.com>
wrote:

>ok sorry - I did upload the file to my home folder which is on my network
>solutions space
>I was told that when I log into MySQL that it would be able to read my files
>on my server space but so far NOT


http://dev.mysql.com/doc/refman/5.0/en/load-data.html


If LOCAL is specified, the file is read by the client
program on the client host and sent to the server. The
file can be given as a full pathname to specify its exact
location. If given as a relative pathname, the name is
interpreted relative to the directory in which the client
program was started.

If LOCAL is not specified, the file must be located on the
server host and is read directly by the server. The server
uses the following rules to locate the file: [etc...]
--
( Kees
)
c[_] Once a newspaper touches a story, the facts are lost
forever, even to the protagonists. (Norman Mailer) (#344)
Reply With Quote