Bulk Loading

[tambo]

Hi,

I'm using the following SQL to load a text file into a database:

LOAD DATA LOCAL INFILE 'mydir/mydir/mytextfile.txt' INTO TABLE X_Table FIELDS TERMINATED BY '\t' ENCLOSED BY'"' LINES TERMINATED BY '\n';

I keep getting the following error:

ERROR 1148: The used command is not allowed with this MySQL version

I'm using MySQL version 3.23.49a. I've read something about this being an improvement because of secuirty issues but that really doesn't help me much. I've also read something about LOCAL INFILE9[=1] but again I'm not sure how this helps me.

If anyone has some advice or can steer me in the right direction that would great.

Cheers,

Tambo

[LordShryku]

Take a look here. I'm thinking LOCAL is the problem, since it's a wildcard.