Hi all,

I'm a newbie with MySQL and my first attempt to follow the tutorial steps leads me to
mysql>LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
ERROR 1148: The used command is not allowed with this MySQL version
so I check my version, which happens to be 4.0.12...
Any clue or did I miss a line in the manual??

Thx

Eg

Two thoughts:

a) Is your (4.0.12) MySQL daemon a pre-compiled binary that you downloaded yourself from the MySQL web site, or a version you compiled yourself, or a version that was compiled by a third party? When compiling MySQL, there are a number of switches available to allow you to provide / not provide certain facilities, and I am wondering if you have a trimmed-down version running; these days, I personally use the "max" binary download version which includes everything.

b) What version of the MySQL client are you running on your loacl machine?   Is it also 4.0.12, or is there a chance that you have a much older version?   The "local" infile load is a bit different to most MySQL commands in that it requires interaction within the command between the client and the server, and you may get unexpected results such as you report if the client is way out of date

Well Graham,

the complete answer to the select version(); query is 4.0.12-max-debug. I simply got the currently most stable version available on the MySQL download page, and as a beginner I didn't seek trouble taking anything else than the precompiled one, i.e. my client and server are the same generation.
Besides I checked the value of the local_infile global variable and it is ON.

Eg

---