Re: Re: Import data from textfile

Hello again, I am still stuck with this bug. Can some one advise me, how to find out if I have the FILE privilege on my DB or not. Thanks again Pushpinder On Tuesday, January 6, 2004, at 12:08 PM, Michal Oskera wrote:

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

--PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php