PDA

View Full Version : error phpmyadmin when importing cvs-file


InnerSelf
06-22-2004, 07:14 PM
if i am in my phpmyadmin and i am sitting in a table to put data in the table trough a cvs-file then i am getting a error back (takes a long time also)


-----------------------------------------------------------------------------------------------
Error

SQL-query :

LOAD DATA INFILE '/tmp/phpwA8z6g' INTO TABLE `table01` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

MySQL said:


#1045 - Access denied for user: '***@localhost' (Using password: YES)

-----------------------------------------------------------------------------------------------


greeting innerself..

Dean C
06-22-2004, 07:46 PM
Hmm that error is usual for when the password for mysql is incorrect. Do you have some kind of connection within the cvs file?

InnerSelf
06-22-2004, 08:15 PM
no, its adding 45870 the same kinda lines. no weird things inside.

InnerSelf
06-23-2004, 04:04 PM
also the smallest files with only 4 simple lines he is rejecting.

InnerSelf
06-25-2004, 02:13 PM
anyone who knows the kinda errors in MySQL?

cause i still didnt figure it myself out