CMS Made Simple Forums

Hi there,
A few days ago my web host let me know that they were moving the mysql databases to a new server. They provided the new connection string mysql2.sqlsvr.net and the move would take place last night. So, I downloaded the config.php files for the 5 sites, saw where the connection string was and changed it, then uploaded config files back to their appropriate web sites.

I should have known that it couldn't be that easy. I wake up this morning and all 5 sites are down.

Here is the message I get:

Database Connection Failed
Error: Unknown MySQL Server Host 'mysq12.sqlsvr.net' (11004) (2005)
Function Performed: CONNECT
Host/DB: mysq12.sqlsvr.net/spa
Database Type: mysql

Can anyone tell me what I need to do now?

Thanks,
Kristy

Hello,

please check with your hosting provider these parameters :
-hostname (or IP)
-port
-database name
-dbuser name
-dbuser password

Is you database actually named "spa" ?

Pierre M.

Hi Pierre,
Yes the database name in this cas is spa. Here's what the hosting provider said that started all of this.

We will moving all mySQL databases from SQL5 to a new mySQL database server during this event.

This move will require you to change your database connection string to a new url/ip, after
the migration. You will want to update your website application code or odbc dsn's to reflect
this new change.

Please use the following database connection url after the move:  mysql2.sqlsvr.net


NOTE: If your website relies on a connection to this mySQL database, please be aware that
your website will not function until after you have updated the database host url/connection
string in your code.

I"ll get in contact with them and ask the questions you suggested.

Thanks,
Kristy

If nothing else you may want to try putting in, FTP, your old install, from the appropriate ver., and rerun install W/O CREATING DB...

Thank you everyone!! It seems that it was a typo on my part


Kristy