Re: Import data from textfile
| From: | Michal Oskera | Date: | Tue, 06 Jan 2004 17:08:53 +0000 |
| Subject: | Re: Import data from textfile | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-173870@lists.php.net to get a copy of this message | ||
Hi,
ensure you have FILE privilege on the db-server host.
Mike
"Pushpinder Singh" <pgarcha@adelphia.net> píse v diskusním príspevku
news:CED3FC2F-4067-11D8-9A12-000393874598@adelphia.net...
> Hello All,
>
> I am trying to import data into MySQL DB using a CSV file (using
> phpMyAdmin as the DB Admin tool). I keep getting the following error.
>
> SQL-query :
>
> LOAD DATA LOCAL INFILE '/tmp/phpYRmG0A' INTO TABLE
>
contacts FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\n'(
> company , first_name ,
> last_name , pri_practice ,
> phone_1 ,
> city , state
> )
>
> MySQL said:
>
> Access denied for user: 'master5503@localhost' (Using password: YES)
>
>
> Here is the CSV file:
>
----------------------------------------------------------------------------
----
>
>
>
> Any insights will be appreciated,,,, I had this thing working before
> but now I dont know why it seems to be acting up. Thanks in advance.
>
> Pushpinder