I was having the exact same problem until yesterday. The mistake was that the data files should be in the c:\mysql\data subdirectory and not in the c:\mysql\bin.
I am not sure about your environment. If it works for 1 file and not for another, you can use a search command to list all the places where you have saved the file and then try loading up the text files in the other directories one by one to see which one works.
Good luck! I'm sure you'll come thru!
Bye now!
Savitha
diane wrote:
Hello,
I am trying (for admin purposes) to load data from a text file in a folder into my database.
I have used
load data infile "./prices/text.txt" into table tablename;
but it keeps telling me it cannot find it and yet when I open the directory in PHP and view the files sure enough it is there.
I realise it is most likely the path is wrong could any one give me any suggestions?
my site name is http://cosmic.cybersol.com.au
and when I ftp my info the folders are
/cosmic/prices/textfile.txt
Di
