how to restore site on new server

[tifo]

I need help in restoring a site to a new server as i moved hosts.

I have uploaded all the files by FTP and the database by phpmyadmin. So the files are in my webspace and the tables are in the database. I have changed the config.php file with the new settings.

The site does not work, i get the message "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

Also, where is the actual content for the pages kept in the database as i would like to extract this information and use it on a new installation, which may be easier than getting the old site to work.

Thanks.

[Luckyluke]

Hoi,

Did you perform every step like in the HELP pages? 

Luc

[tifo]

i'll have a look.

i did it the way i said above, not a new installation.

uploaded old files to webspace, put tables into database from backup, changed config file with new database settings ....

[tifo]

new installation gives the same message :

Database host name, username and/or password incorrect. MySQL Error:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[Luckyluke]

Maybe the name and password of the database are different from the old one.
Dit you change everything in the file config.php in the root of your WB site?

Something like:

define('DB_TYPE', 'mysql');
define('DB_HOST', 'localhost');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'password');
define('DB_NAME', 'databasename');

take a look...