Running MySQL 4.0.14-nt and trying to upload to phpmyadmin 2.5.6
I exported a CSV from Excel and when uploading I get this error(for data local):
Error
SQL-query :
LOAD DATA LOCAL INFILE 'C:\\Backup\\dot\\uploadtemp\\php673.tmp' INTO TABLE `agencies` FIELDS TERMINATED BY ','
MySQL said:
#1148 - The used command is not allowed with this MySQL version

If I try the other upload option(data), I get a "permission" type error.
Error
SQL-query :
LOAD DATA INFILE 'C:\\Backup\\dot\\uploadtemp\\php85C.tmp' INTO TABLE `agencies` FIELDS TERMINATED BY '' LINES TERMINATED BY ','
MySQL said:
#1045 - Access denied for user: 'wnyic@%' (Using password: YES)

I am new to this and need rather simplfied instruction.
Can you point me in the right direction?
I appreciate any help.. ;-)
bufhal

I have never been able to upload using DATA but DATA LOCAL has always worked for me. Do you have command line access to the remote computer? You could run the query from the mysql prompt and that should work. It would be something like:


Note the changes in FIELDS TERMINATED BY and LINES TERMINATED BY

__________________
Web Hosting Tips | Career Advice

At this time, I am not at the skill level to "shell in" the data via command line-is it something easy to learn? Are there any basic tutorials? PHPMYADMIN just seems to be more trouble than it is worth for me.. I need an "editor" to upload formated text or CSV files. Any ideas for a newbie?
thanks again
:-)

You can use MySQL frontends like MySQLFront (http://www.mysqlfront.de/), but I don't know if they work in every environment. That is, I don't know if you'll be able to use them with a MySQL server hosted by your webhosting provider.

__________________
Web Hosting Tips | Career Advice

Thank you for your help. I will look into other tools. This is a great forum, and you a great moderator...
Bufhal :-)

Hello;
I have tried a few things to simply upload a text file to mysql via phpmyadmin. When I do, all my dropdown menu querys bring back "no results found". However, when I insert manulally one row at a time in phpmyadmin, the querys work.
Can anyone tell me what I am doing wrong?
Here is a text file record with the first column empty for auto-increment:
, Akron , Blue Cross , 11/18/2004

, Tues , 2-4 pm , Akron Newstead Senior Citizen

, pharmacy , 5691 Cummings Rd , 14001

, 542-7777 , Bill Roach ;

Thank you for any help and feedback!