Moved to new server - query re: locating SQL files

[kali]

Due to some problems with my old webhost I've transferred my Coppermine database (v 1.4) to Bluehost. I've re uploaded my images (keeping the same file structure) and I've got a zipped backup of my SQL databases.

I've reached a stumbling block on this part of the instructions:

* restore the mySQL table by running the queries of the dump files you created in step 2

How exactly do I do that? I'm guessing I need to reupload the SQL files onto my new server (they're now on a subdomain of the domain on the new server)- but I'm not too sure where I should be putting them.  I've only ever done brand new installs of Coppermine before now.

[Paver]

The MySQL backup you have is a series of MySQL commands.  You need to execute those commands on the new server to restore your database.

In phpMyAdmin, there's an SQL tab.  Click on that and then you can choose a file with the SQL commands or you can paste in the commands into the text box (not recommended for large pastes).

Before you do that, take a look at your MySQL backup.  Make sure that if the database name is shown in the queries that the new database name is the same.  If the database name is not shown in the queries, make sure to click on the SQL tab for the database in which you want the Coppermine tables to reside.  With no database name, the MySQL commands are "relative".  With a database name explicitly mentioned, the commands are "absolute".  If the database name is mentioned, but your new database doesn't have the same name, you need to find & replace to replace all the database names with the new ones.  Keep a backup of your backup before doing so.   

The way you backup your database determines whether the commands are relative or absolute.

[kali]

Ah, thank you.

So far so good. I now have the database on my domain. It's still not quite there though. When I try and run Coppermine I get this error message:

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'stakesandst'@'localhost' (using password: YES)

The MySQL on bluehost is configured so that the usernames are always prefixed with part of your domain name (e.g. domainname_stakesa). What file do I need to edit to match up the new username and allow the database to connect?

[Paver]

include/config.inc.php

[kali]

I just wanted to say thank you for all your help. My gallery is now back up and running and it was thanks to you. So thanks. 

[Paver]

You're welcome.  Thanks for returning to close out this thread.

Marking "solved".