Read documentation & faq, but still confused about how to move to new server

[Jamhin4]

Your FAQ reads as follows:
How can I move my gallery to another host?

• Backup your files: FTP-download your complete coppermine-folder to your hard drive
• use a tool like phpMyAdmin to get a dump (backup) of your mySQL database entries. More info here
• verify your backup is working: check if the mySQL-dump contains all data (open the zipped dump file and use a text editor to view it)
• on the new server: FTP-upload your coppermine-folder to the new server
• CHMOD the folder /albums to 755 or 777 (depending on your server config]
• restore the mySQL table by running the queries of the dump files you created in step 2
• test-drive your coppermine gallery - you should be done

It looked simple, but now I see that I need more instruction than this and cannot seem to find it anywhere in any other documentation.  Here are my questions:

I've gone through all the steps listed above, but I do not understand how to go about running the queries that are contained within the .sql backup file.  I'm new to working in this area, but I thought it should probably be done in phpMyAdmin, but when I tried to look up the database to run the queries on, that database does not show up in the drop-down list.

Is there some other way to run these queries - to execute the .sql file outside of phpMyAdmin?  Should I upload the .sql file within a directory inside the Coppermine folder and try to call on the file within a browser or something?

I'm completely lost.  I have literally THOUSANDS of photos and files in this gallery that I'm trying to move and can use all the help I can get here.  If no one feels like giving me a step by step procedure for how to do this, perhaps there is other documentation that one could point me to???

MUCH THANKS for any advice you can provide!!!

[Nibbler]

The phpmyadmin documentation should explain how to import an sql file. Basically you use the 'import' tab in phpmyadmin and then use 'browse' to locate the .sql file on your PC. You might need to create the new database yourself first. If you are on shared hosting then you might need to do this in cPanel or whatever else your host provides. We can't give set by step instructions since the steps vary so much depending on your hosting arrangements and server setup.

.sql files are only text, you can't 'run' the file.

[Jamhin4]

Thanks Nibbler for your reply.  It at least set me down a better path, I think.  I created a new database, edited the .sql file to work in the new database, ran the script in phpMyAdmin and it did create tables in the database.  But when I try to pull the gallery up in the browser, I'm seeing that it is still looking for the old user that was used for the old database.  Here's what I see when I try to pull up the gallery:

Coppermine critical error:
Unable to connect to database !

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

I've been searching through tables and through the pages within my CPG folders, to see if I can find some reference to jamhin4_jam, thinking I could replace that with the username that was assigned to the new database, but I'm not finding it anywhere.  (I'm unable to change the username for the sql database within my cpanel, because everything ends up having a prefix for my website in front of it - the new username is starlitd_copp3, but I was able to set the password to match the old password - if that makes any sense at all.   

If anyone knows where I might be able to change the username within the Coppermine files or tables, I might be a little closer to my goal and would be ETERNALLY GRATEFUL!  THANKS!!!

[Nibbler]

include/config.inc.php

[marine0311]

Coppermine critical error:
Unable to connect to database !

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

What that error means is that you either entered the wrong user name or wrong password. Remember user name and password are case sensitive. Also make sure you have the right database name. The user name and password are unique for each database you create.

If you do not have phpmyadmin to import your .sql database file you can use phpbigdump (link below)

phpbigdump

If all else fails you can do it through a terminal window a good program for this is called putty a telnet/SSH client that is easy to use. (see link below)

putty telnet/SSH client

If you need any more help, Feel free to ask.