1. Home
  2. Community
  3. General Questions
  4. Moving

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Moving

General Questions 916 This topic was started by ,


avatar
mistix 0
From: -
Moving

Hi

I am moving servers, I have had the SQL databases moved over to the new server and moved over all the files through FTP, how do I get it to update?

It says

Error: Can't connect to the MySQL server

Why is this? It should work

Can I do a fresh install maybe? is there a way to put all the old reviews and news back in, or will this be in the SQL DB?

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: Moving
avatar
OP 0
From: -
Moving

Nice one mate, just got to wait for my host to enable the namservers now >_< a week of downtime.
1 Re: Moving
avatar
Administrator
1342
From: Austria
Moving

It look like the SQL login (username / password /database) is different on the new server.

To update config.php, download this script and open it in an editor:
 http://www.esselbach.com/scripts/cfix.php.txt

Now change the settings to match your new configuation:

//MySQL settings    

$dbhost = "localhost";

$dbuser = "root";

$dbpass = "password";

$dbname = "database";    



//Website details

$wsname = "Website";

$wsurl  = " http://localhost";


Rename the script to cfix.php and upload it to your /cadmin directory. Finally, run the script from your browser. Once this is done, remove the script again.

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.