phpmyadmin file upload on windows server ?

[benpaul]

Hi, I have recently bought some hosting space on a windows server ( that runs php and mysql ), the problem im having is that after uploading phpmyadmin and setting the config files I try and upload a csv file of my old stock to the server via phpmyadmins "load data from textfile".

problem is that i point it in the direction of the text file and set the various options that it needs to know like "fields terminated by:" etc etc... press submit and this is the error message i get.


LOAD DATA INFILE 'C:\\WINDOWS\\TEMP\\phpC58C.tmp' INTO TABLE `tunes` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'

MySQL said:


#1045 - Access denied for user: 'changed for privacy' (Using password: YES)



im sure this is something to do with the unix / windows thing... so does anyone know how i can change phpmyadmin to make this work ??

Thanks

[TheIceman5]

Originally posted by benpaul
Hi, I have recently bought some hosting space on a windows server ( that runs php and mysql )

Thanks

you poor person, i feel for you. you made a mistake, but alas it can be corrected.

winblows, who knows, i cant ansswer your problem, winblows is not part of my vocabluary as it sits next to swiss cheese in my fridge, i cant tell them apart, windows has somewhat more holes than my swiss cheese.

so if your server place has a 30 day money back guarantee, take them up on it and move to unix.