[Resolved] [Resolved] load data local infile not working - why?

conjurer

I am running version 4.0.12.NT on a Win XP Pro OS.

I am trying to work through the MySQL book by DuBois. When I try to run a load command I get an error.

From the mysql prompt I entered:
LOAD DATA LOCAL INFILE 'member.txt' INTO TABLE member;

What I get is:
Error 1148: The used command is not allowed with this MySQL version.

Why is Load Data command not working? How can I fix this?

I should add that if I go to command prompt and use
mysqlimport --local sampdb member.txt
that works. The file loads.

😕

jayant

Try giving full command

LOAD DATA LOCAL INFILE 'filename'' INTO TABLE tablename FIELDS TERMINATED BY ...

workd at my side. though, i am still using mysql 3.23.32

Norman_Graham

Hi Conjurer

I had that problem too. It works if you drop the 'local' command: LOAD DATA INFILE

HTH

Norm

conjurer

Thanks!

I'll give that a try.

conjurer

Tried that ... now I get a different error:

LOAD DATA INFILE 'member.txt' INTO TABLE member;
ERROR 1105: File '.\sampdb\member.txt' not found (Errcode: 2)

Which I don't understand because the current directory is where the file is located. When I do a "dir" at the cmd prompt it returns:
Directory of C:\Documents and Settings\RLane\My Documents\Active Web Sites\Localhost\sampdb

and the listing of files shows the member.txt file.

Are we getting closer?

😃

Norman_Graham

Try sticking the file in the c:\mysql\data folder, that's where mysql looks for the files, I think.

HTH

Norm

conjurer

I was able to get it to work when I put it in c:\ and then specified the file as 'c:\member.txt'

And I can do it when I specify it as the full path name with double slashes.

I just don't undersand what directory it is actually looking for because the error it reports is indicating that it is looking for .\sampdb\member.txt when "." is already pointing to sampdb directory.

Weird. 😕