Import data from textfile
| From: | Pushpinder Singh | Date: | Tue, 06 Jan 2004 16:46:00 +0000 |
| Subject: | Import data from textfile | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-173868@lists.php.net to get a copy of this message | ||
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: