View Single Post

  #7 (permalink)  
Old 01-03-2008
don
 
Posts: n/a
Default Re: can't read file into a table


> MySQL can't just go fetch a file from a URL like that. You need to
> specify the local path /in the filesystem/ where the file resides.
> Something like:
>
> LOAD DATA LOCAL INFILE '/home/foo/pet.txt' INTO TABLE pet;
>


Thanks for looking at my problem - I have 2 MySQL accounts, one with
Panix.com and this new one with Network Solutions - In the Panix terminal
window I have no problem using this LOAD DATA..... command

for some reason Network Solutions is Fubar !



Reply With Quote