Ok, I need to upload a small PHP-Nuke MySQL database (about 400k). I have it in .txt format. I was told I can do it with phpMyAdmin. Can anyone tell me how?

this will all depend on the version you have....

once you've created your database....
1)Open up phpmyadmin in the browser
2)click your database in the left pane
3)click on SQL on the right pane - it will be at the top with all the other options

4) in the new page, click browse file to select your file and click Go

note: your .txt file will need to have the proper mySQL instructions(query) to insert the database

akash is spot on, if that doesnt work try pasting it into the query box and running it :)

Ok, I'll try that. The version is 2.3.1.

Hmm well I've uploaded everything but now I get this when I try to go the main page:

Error

MySQL said:


Access denied for user: 'mikhailtech@localhost' (Using password: YES)


Is this a password problem?

the uesrname needs to be in the following format:

cpanelusername_databaseusername

the same goes for the databasename:
cpanelusername_databasename

Hmm turns out they didn't set up any MySQL users so that's why. Fortunately my sales rep/director said (according to our previous agreement) that he'll talk to his techs and try to get everything set up Monday. Which is good, cause I know jack-poop about MySQL and next to nothing about SSH. And I don't have time to learn it all either, maybe some here and there but probably never enough to run my own server.

And no I don't have CPanel, I was advised against it by the sales director because it costs more and would limit the amount of support I could be given. So far I'm impressed at ServInt's response time; we'll see how things go.

Don't worry I will write a review maybe a month or two from now.

ah ok...well if ya need help we're all here :D

btw, what control panel are you using? or are you doing it all via ssh?

I'm not using a control panel. As I mentioned earlier, I was advised against it because it would "limit the amount of tech support" I could receive. And it would cost an additional $60/month. So yes I'm pretty helpless.