From owner-freebsd-questions@FreeBSD.ORG Sun Sep 21 20:18:27 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BECC116A4B3 for ; Sun, 21 Sep 2003 20:18:27 -0700 (PDT) Received: from mail.zoper.com (216.93.178.62.beta.zettai.net [216.93.178.62]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9E91D43F85 for ; Sun, 21 Sep 2003 20:18:26 -0700 (PDT) (envelope-from list@zettai.net) Received: (qmail 30194 invoked by uid 7794); 22 Sep 2003 03:18:26 -0000 Received: from list@zettai.net by mail.zoper.com by uid 89 with qmail-scanner-1.16 (clamscan: 20030522. spamassassin: 2.55. Clear:SA:0(-4.8/5.0):. Processed in 0.626396 secs); 22 Sep 2003 03:18:26 -0000 X-Spam-Status: No, hits=-4.8 required=5.0 Received: from unknown (HELO ?192.168.0.2?) (list@zettai.net@200.71.46.3) by 0 with SMTP; 22 Sep 2003 03:18:25 -0000 User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.6 Date: Sun, 21 Sep 2003 22:18:15 +0000 From: george donnelly To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Subject: mysql 4.0.14 LOAD DATA INFILE problems on freebsd 4.8 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Sep 2003 03:18:27 -0000 hi all, is anyone else having problems with importing data files into mysql 4? Regular users (who have all privs on their db's and usage on *.*) are unable to import files into a mysql 4.0.14 install on freebsd 4.8. the error is 1045 access denied, when using LOAD DATA INFILE. I have tried starting mysql client with --local-infile, --local-infile=0, --local-infile=1, putting these values in my.cnf, starting mysql server with these variables and even hacking the mysql port to enable this and yet nothing seems to work. mysql always reports that the infile variable is on. local_infile | ON has anyone else experienced this? i have done a lot of work on this and am out of ideas. can anyone suggest what strategies i might take with this problem from here? thanks <--> george donnelly ~ http://www.zettai.net/ ~ "Quality Zope Hosting" Shared and Dedicated Zope Hosting ~ Zope Servers ~ Zope Websites Yahoo, AIM: zettainet ~ MSN: zettainet@hotmail.com ~ ICQ: 51907738