Switched servers mysql reconnect problem

[Scooby22]

I recently switched servers and transferred my entire joomla folder over via ftp. I have created the new mysql database but I am not sure how to reconnect with the new database without the installation folder. I do feel comfortable ftp-ing to a file and editing a name somewhere if I have to. I am using Joomla 3.

This is the Error I get when trying to view the site:

Error displaying the error page: Application Instantiation Error: Could not connect to MySQL.

[itoctopus]

You will need to edit the configuration.php file. The host , the db name, the db user, and the db password may not be the same. You will need to change those.

[Scooby22]

I did that, and entered in all the new settings. Now I am getting this error.

Error displaying the error page: Application Instantiation Error: No database selected SQL=SELECT `session_id` FROM `aaxcg_session` WHERE `session_id` = 'gs0oeidjvpd9v1dgd7d796jfj6' LIMIT 0, 1

Could this have something to do with the prefix?

[AMurray]

The first part of the error "No database selected" seems to mean it doesn't know where to find the table, aaxcg_session, but I'm no MySQL expert. There's definitely an issue with the database connection.

Perhaps as you suggest it is to do with the table prefix, so check this setting below in configuration.php:

public $dbprefix = '.....';

Did you actually import the old databases's tables and data into the new database? Or intend to start from scratch? How did you back up the old database and import it into the new one?

If you are familiar with it, try viewing the database in phpMyAdmin and checking for the table with that prefix mentioned in the error.

If you did a database backup (even if only an export to a *.sql file (you did back up didn't you....?) then try reimporting the database again through phpMyAdmin.

The easiest solution would have been to use Akeeba Backup - to backup the original site, and to transfer/migrate to new server with Akeeba Kickstart. Probably a bit late now if you have already taken down the original site.