Post database migration problems

[Cognatus]

Hi!

My host have done a migration to a new platform and in this process changed the name and credentials of a couple of databases connected to sites where I run CMSMS. The sites are down and I can't access the admin panels in CMSMS.

I obviously didn't read the documentation regarding the migration thoroghly enough so here I am, asking for advise!

Can I solve this in a swift way by editing DB-credentials for CMSMS through phpMyAdmin to get the sites up and running again?

Please say I can!

/C

[Rolf]

You need to change the database name and credentials, and perhaps server path in the config.php file! Clear cache after that.

[Cognatus]

Thanks for the answer, but it wasn't as easy as I hoped for me who aint an expert on these things!

I have tried to change it but can't get it to work. Someone, please advise!

This is the content my old config file:

Code: Select all

<?php
# CMS Made Simple Configuration File# 
Documentation: /doc/CMSMS_config_reference.pdf#$config['dbms'] = 'mysqli';
$config['db_hostname'] = '83.168.227.23';
$config['db_username'] = 'u1123260_mgstad';
$config['db_password'] = '################';
$config['db_name'] = 'db1123260_mgstad';
$config['db_prefix'] = 'mgstad_';
$config['timezone'] = 'Europe/Stockholm';
?>

And this is the info from phpMyAdmin:

Server: 10.209.41.8 via TCP/IP
Server version: 5.5.52-MariaDB-cll-lve
Protocol version: 10
User: 2004707_umgstad@10.211.59.34
MySQL charset: UTF-8 Unicode (utf8)

And this is the new credentials that my host sent me:

New database credentials for db1123260_mgstad:

Host: dbmgstad-2004707.mysql.crystone.se
Database: 2004707-dbmgstad
Username: 2004707_umgstad
Password: ###############

[Rolf]

The most obvious way would be:

$config['db_hostname'] => Host
$config['db_username'] => Username
$config['db_password'] => Password
$config['db_name'] => Database

And after that clear cache!

If that doesn't work you should contact your web host. Nothing we can do here...

Grtz. Rolf

[Cognatus]

Thanks Rolf

It seems like I managed to access the DB with your help, but new problems occurs. Now I get a 404 instead of a DB error message.

"Not Found

The requested URL was not found on this server."

Any ideas?

//C

[Rolf]

Problem started after the web host made changes. Only they know what was done and how it can be fixed. I can give you several pointers but all of them assumes a normal stable hosting.

So contact your web host first.

[Rolf]

Problem started after the web host made changes. Only they know what was done and how it can be fixed. I can give you several pointers but all of them assumes a normal stable hosting. So it will be more like guessing what could have happened.

So contact your web host first.

[Cognatus]

I have contacted the support but no answer yet. I have a hunch that they will point at my CMS...I will get back when I know.