Got error on migrating prestashop to other server

[flippin]

Hi,

 

I tried to migrate my site to new server and i got below error. Kindly check and help me to resolve this.

 

Link to database cannot be established: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

 

Steps done:

 

1. Created new database on new server

2. import existing database to new server

3. uploaded files to new server [vdeck panel]

4. updated settings.inc.php in config folder

5.updated new nameserver details to domain.

 

Regards

Parthi

[tuk66]

The database server, database name, user or password set is wrong. Can you check it outside PrestaShop?

[flippin]

I checked settings.inc.php under config folder.. everything is fine.. what else need to check.. i am not using cpanel.. its Vdeck...

[flippin]

I have changed the mysql server name and its connecting now. But home page only opening other pages not able to open.. it says page not found.. any help ?

 

[kishoreunni]

have u transferred img folder from local to ur remote, defines.inc.php file its found in config/     define('_PS_MODE_DEMO_', false); this false to true, change PS_SHOP tables fields domain,domain_ssl,physical_uri to one that is corresponding to ur remote servers fields.

make sure u know what u have done if any error comes try to restore these things to ur earlier settings so make a copy of these things and do wat is said above.

 

hope it can work

[flippin]

now all set.. I have cleared cache. thanks for your support guys..