How to transfer a mysql database

[LAFitz]

I'm new to BH and have managed to transfer my site from my previous host with no problem other than with my Forum created in punBB. When I try to login, I get this message:

Error: Unable to connect to MySQL and select database. MySQL reported: Access denied for user 'orgmind0_admin'@'localhost' (using password: YES).

The user mentioned is from my old host. So how do I make the necessary changes to make it work in BH? Is there a tutorial on this issue? Please advise.

Laurie :eek:

[felgall]

You have to update the config file for the script you are using for the forum to supply the correct connection info for where the database is now.

[LAFitz]

Thanks for your prompt response...which leads to more questions: Is there a way to update the config file (for punBB) from within the CPanel? And if not, where would I find that file? Is this something only a technical expert in the script can do? I'd much rather do it myself as part of my learning process but don't want to mess things up.

Laurie:o

[felgall]

It should be just a file somewhere in amongst the ones you are transferring. Someone who uses punBB should be able to help you out with finding it.

cPanel has no idea you are running that particular script and so has no options for it at all.

[LAFitz]

Thanks. I'll search for someone who knows punBB.

Laurie :)

[LAFitz]

I have now changed config to point to my new login/password, but am now getting a different error message:

Error: Unable to connect to MySQL and select database. MySQL reported: Access denied for user 'orgmindc_admin'@'localhost' to database 'orgmindc_punbb'.

As far as I can tell, there is no such database as 'orgmindc_punbb'. Should I rename the one I have currently?

Laurie

[felgall]

Is there something in the config where you can specify the name of the database? If so then that's the easiest way to fix that.