RE: [PHP-DB] Load data infile
| From: | Sanders, Nicholas | Date: | Mon, 11 Dec 2000 09:54:52 +0000 |
| Subject: | RE: [PHP-DB] Load data infile | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5147@lists.php.net to get a copy of this message | ||
It means that it can't open the file. (File permissions not database
permissions)
It needs to be visible to to the user 'mysql'
-----Original Message-----
From: John Hanson [mailto:jhanson@a440studios.com]
Sent: 11 December 2000 09:27
To: php-db@lists.php.net
Subject: [PHP-DB] Load data infile
I'm having problems using this code...
$sql="load data infile
'/home/httpd/html/evision/pfc/admin/transfers/up/member.txt' INTO TABLE
member"
$result=mysql_query($query,$mysql_link);
I'm getting a return of "Access denied for user: 'prairie@localhost' (Using
password: YES)" this is odd as
I can do all other queiries with this username/DB combination. I have
Select,Delete, Update, Insert rights set for this user but can't do the load
data infile command. Anyone know of a possible reason as to why not?
Thanks,
John Hanson