MySQL, loading data into a table from a textfile problem

Tar.Aldarion

I'm trying to populate a table using a text file. For the life of me I can not find why it is not working.
Here is what I write:

mysql> LOAD DATA LOCAL INFILE 'C:/Documents and Settings/Paul/Desktop/active.txt'
INTO TABLE active;
ERROR 2 (HY000): File 'C:\DocumentsandSettings\Paul\Desktop\active.txt' not found (Errcode: 2)

Anybody know how to fix this rather trivial thing?
I have no idea why it can not find a file no matter what I do.

Ginger

Quick fix, through the file to the C drive and then amend the file path and it will work

The answer is to the \ before spaces in Documents And Settings to make it work

Tar.Aldarion

Hi, the first thing I tried was putting it in the c drive and it still did not work. File could still not be found. I don't follow your seond sentence, the spaces in Documents And Settings are the problem?

Ginger

'C:/Documents\ and\ Settings/Paul/Desktop/active.txt'

Should do it I think, its been a very long time since i used mySQL

Tar.Aldarion

Thanks mate, I fixed it. It was odd, I changed the name of the file and it worked...
Anywy, cheers for the help.