Mregina Posted September 8, 2006 Share Posted September 8, 2006 hey all. i'm having a problem here. i'm trying to upload a table into the database. i've tried .csv, excel, .txt, word... and none work. if i select DATA as my upload method i get the following error: #1045 - Access denied for user: 'clearpo_master@localhost' (Using password: YES) and if i use DATA LOCAL i get: #1148 - The used command is not allowed with this MySQL version so im confused. ive tried it every which way except the right way apparently. im running phpMyAdmin 2.5.3 with MySQL 4.0.24. if anyone could give me a tip, i'd appreciate it. Quote Link to comment Share on other sites More sharing options...
Caesar Posted September 8, 2006 Share Posted September 8, 2006 What does the dump in the file you're trying to upload look like? Have you tried using .SQL files? Can you paste part of the data here so we cam see in what format you're trying to upload it? Quote Link to comment Share on other sites More sharing options...
Mregina Posted September 11, 2006 Author Share Posted September 11, 2006 Sure, it is very simple data:I tried saving it as .sql and upload it..same results. The column headers are exactly the same as the database headers...same results:prodnum size cup style color status discontinued0200000000 0 0 0 0 0 00207000000 0 0 0 0 0 00218000000 0 0 0 0 B/O 00218003200 32 0 0 White B/O 10218003400 34 0 0 White 0 00218003600 36 0 0 White 0 00218003800 38 0 0 White 0 00218004000 40 0 0 White 0 00218004200 42 0 0 White 0 00218004400 44 0 0 White 0 00218004600 46 0 0 White 0 00218004800 48 0 0 White 0 00218013200 32 0 0 Black B/O 10218013400 34 0 0 Black 0 00218013600 36 0 0 Black 0 00218013800 38 0 0 Black 0 0 Quote Link to comment Share on other sites More sharing options...
Jenk Posted September 11, 2006 Share Posted September 11, 2006 your password might be wrong, or you have incorrect privileges for that userid. :) Quote Link to comment Share on other sites More sharing options...
Mregina Posted September 11, 2006 Author Share Posted September 11, 2006 Jenk,Yes, I think that is my main issue...I'm not sure how to change my privileges..I assumed I was the 'God' admin...but for some reason it will not allow me to upload this data. Any idea where I can change user privileges? Quote Link to comment Share on other sites More sharing options...
Jenk Posted September 11, 2006 Share Posted September 11, 2006 you can view the privileges in mysql with:[code]SHOW GRANTS FOR USER 'user'[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.