[SOLVED] Sites down-Need help with database connection string

[Kristy]

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

[Pierre M.]

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.

[Kristy]

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

[Dr.CSS]

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...

[Kristy]

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


Kristy