Hi Michael, Yes, I rebuilt it to ensure it was switched on. The configure line was
./configure --enable-local-infile --without-server 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 -----Original Message----- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 3:19 PM To: Logan, David (SST - Adelaide) Cc: MySQL List Subject: Re: LOAD DATA LOCAL INFILE issue Well, as you say, that error message means it's been disabled in either the client or the server. You rebuilt the server from source with --enable-local-infile, and the server says local-infile is ON. You've tried turning it on in the client with --local-infile, but you haven't mentioned whether the client was built with --enable-local-infile. I'm not sure the command line switch does any good if local-infile was disabled at build time. So, did you build the client with --enable-local-infile? Michael Logan, David (SST - Adelaide) wrote: > Hi Michael, > > Thanks. I rechecked things but > > porkribs /u2/lcscreative/sql_scripts $ mysql --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 > > Still a most unhappy camper. I had to resort to placing the file on the > server, owned and group mysql in the datadir before it would work. Even > though I did chmod 777 on the file, it was still upset. > > I am running Solaris 8 on the client and 9 on the server. I don't know > whether this would make a difference, I can't understand why it would. > > 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 > > > > -----Original Message----- > From: Michael Stassen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 10 August 2004 2:37 PM > To: Logan, David (SST - Adelaide) > Cc: MySQL List > Subject: Re: LOAD DATA LOCAL INFILE issue > > > Perhaps the problem is that there is no such option as > --enable-local-infile > in the mysql client. I believe you want --local-infile. Client options > are > detailed in the manual <http://dev.mysql.com/doc/mysql/en/mysql.html>. > > Michael > > Logan, David (SST - Adelaide) wrote: > > >>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 >> >> >> > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
