RE: [PHP] Load Data Local Infile
| From: | Jay Blanchard | Date: | Thu, 02 Sep 2004 12:04:57 +0000 |
| Subject: | RE: [PHP] Load Data Local Infile | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-195534@lists.php.net to get a copy of this message | ||
[snip]
I am using the following command and it appears to execute but does not
actually load any data:
LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE
MembersData
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';
Any ideas what I might be missing...?
The file exists, and I must have the path right or would get an error
but
still no joy unfortunately...
[/snip]
Do you have the proper permissions to read the file? BTW, OT.