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