Posts: 147
Threads: 73
Joined: Jul 2013
Reputation:
0
I am trying to upload my .sql file(actually it is .sql.bz2 because it was too big).
But i keep on getting this problem "Access denied for user"
I think it is because my host only gave me the ability to upload one database and they already made one for me.
Note: I tried uploading my file to wamp on my pc and it worked.
Thanks in advance!
Posts: 39
Threads: 1
Joined: Dec 2010
Reputation:
0
You use PhpMyAdmin, right? Import your .sql database there.
Posts: 98
Threads: 18
Joined: Jun 2014
Reputation:
0
Answer these:
What are you using to import this?:
Do you have access to the host of the database?:
Posts: 147
Threads: 73
Joined: Jul 2013
Reputation:
0
yes i am using phpmyadmin but not on my pc on the hosts phpmyadmin but it gives me an error saying:
"Access denied for user"
I want to know what is causing this problem?
Is it that the host doesn't let me upload more than one database?
Because they gave me one when i requested it but it can't delete it and put mine.
Help please!!
Posts: 147
Threads: 73
Joined: Jul 2013
Reputation:
0
@jordan i go to the hosts database and i login then i click on import then i click on choose file then i choose my .sql.bz2 file it loads then gives me that problem.
Posts: 147
Threads: 73
Joined: Jul 2013
Reputation:
0
@icecube! what do you mean by "You should be creating MySQL databases on your first mode connection to that MySQL server anyway."?
Is there a way that i can upload only the structure to my database so that it is not counted as if i am trying to upload two?
Thank you all btw.
Posts: 98
Threads: 18
Joined: Jun 2014
Reputation:
0
ok, Does it say the .sql file is too big?
Posts: 147
Threads: 73
Joined: Jul 2013
Reputation:
0
Yes it said that at first but then i converted it to .sql.bz2 now its only 5mib
