LOAD DATA LOCAL INFILE issue

[Logan, David (SST - Adelaide)]

Hi Folks,

I am having a few issues with a LOAD DATA LOCAL INFILE command. As you
can see by the command below, I am receiving an error 1148. The
documentation states this is generally because I don't have
--enable-local-infile on in both client and server. I have switched it
on via command line below and when I do a show variables on the server,
I see local-infile = ON. I have also tried loose-local-infile in the
my.cnf on both client and server. I have just rebuilt the server
ensuring --enable-local-infile was in the ./configure options.

Both client and server are version 4.0.20 and are on different hosts.
The sql file I am using is

CREATE DATABASE IF NOT EXISTS weblog;

use weblog;

CREATE TABLE IF NOT EXISTS dept
        (department INT PRIMARY KEY,
         main_dept INT NOT NULL,
         description VARCHAR(40));

CREATE TABLE IF NOT EXISTS dns_cache
        (ip_address CHAR(15) NOT NULL PRIMARY KEY,
         hostname VARCHAR(255));

CREATE TABLE IF NOT EXISTS web_rec
        (recnum INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
         date DATE NOT NULL,
         time TIME NOT NULL,
         source_ip CHAR(15) NOT NULL,
         method CHAR(10) NOT NULL,
         department INT,
         source_port SMALLINT NOT NULL,
         username VARCHAR(255),
         c_ip CHAR(15),
         user_agent VARCHAR(255),
         referrer TEXT,
         last_status SMALLINT,
         last_substatus SMALLINT,
         win32_status SMALLINT,
         sent_bytes INT,
         recv_bytes INT);

CREATE TABLE IF NOT EXISTS UserAgent
        (agentnum INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
         browser VARCHAR(255),
         description VARCHAR(255));

CREATE TABLE IF NOT EXISTS Referrer
        (Refnum INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
         ref_uri VARCHAR(255),
         hostname VARCHAR(255));

CREATE TABLE IF NOT EXISTS status
        (status INT NOT NULL PRIMARY KEY,
         description VARCHAR(255));

LOAD DATA LOCAL INFILE '/u2/lcscreative/sql_scripts/categories.csv' <---
Line 46, error 1148 occurs here
INTO TABLE dept
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
(main_dept,department,description);

porkribs /u2/lcscreative/sql_scripts $ mysql --enable-local-infile -u
davidl -p <make_web_tables.sql
Enter password:
ERROR 1148 at line 46: The used command is not allowed with this MySQL
version
porkribs /u2/lcscreative/sql_scripts $

Anybody have any ideas on what I've done wrong?

Regards

David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax