ftp database name change

[RichardODreamweaver]

I have tried and tested a MySQL Database on a testing server and everything works fine.

When we had our ftp site setup, it automatically puts additional info before the db name.

i.e. if the db name on the intranet testing server is "Contacts", it has put in info such as "user_Contacts"

In itself, this is not an issue; however, when synchronising to the remote site, it copies the connection file exactly meaning that when the online site tries to access the database, it cannot be found.

Is there something I am missing or do I have to manually alter all the online .php files to look to the correct place? I have tried altering the connection file only but this does not seem to work.

Can anyone help?

[RichardODreamweaver · Accepted solution]

Had to copy the entire site and then change the database connection in the behaviours