"Link to database cannot be established" after moving Hosting Company [SOLVED]

[Leboeuf]

I am desparate for some urgent assistance. I am halfway through migrating my Website to another hosting company from a bad one.

I backed up my mySQL server using the EXPORT command from PHPmyAdmin and subsequently uploaded it to my new mySQL using the IMPORT Command.

I changed .... \config.php\settings.inc.php by chaning (i.e.) DB-SERVER IP Address

On the new hosting server, mySQL is named exactly as in the Old server. So can anyone tell me WHY I am getting the following [b]"Link to database cannot be established."[/b] after migration.

Thank you.

Desparate from London

[atyno]

config/settings.inc.php

define('_DB_SERVER_', 'localhost');

_DB_PASSWD_ = new password

[Leboeuf]

Atyno,

Thanks for your assistance, but still no joy. In config.stteings.inc, what does - DEFINE('_PS_BASE_URT_', '/'); MEAN?


I am hosting on a VPS, consequently, the path to the home directory is /var/www/vhosts/domain.name.com/http - with all the Prestahop folders in /http. Might this be the reason why?

I am still stuck, but thanks for tryin'

Desprarate in London

[Paul C]

The URI is the bit after your domain name. If the shop should appear directly in the root of your site, then that setting is correct. if you refer to your store like:

http://ww.example.com/shop

then the base URI would be /shop/

Paul

[Leboeuf]

PAUL,

I am sure your French is better than mine!

Thank you for your suggestion which was successful. I am now able to pick up my Index.php, however, there are no images (ples see attachment) beacuse clearly, the website cannot connect to the database.

The database was migrated using PHPMyAdmin (Export) and Imported at the new host with PHPmyAdim.
I set up exactly (a) the same databse user names and password as per my old host ( I named the database the same name as per my old hosting company database. Also, I checked the "Collation" parameters was the same for both dataases. So, to that extent, I have tried to forestall any incompatibility issues; yet I am having problems. B y close of play today if I haven't solved this, I'll be taking them up on their 30 Day Money Back Guarantee.

Also, pls find below a copy of my /settings.inc.php

<?php

define('__PS_BASE_URI__', '/httpdocs/');
define('_THEME_NAME_', 'woody_pro');
define('_DB_NAME_', 'yagbebi_prestacart');
define('_DB_SERVER_', 'localhost');
define('_DB_USER_', 'yagbebi_ptheme');
define('_DB_PREFIX_', 'ps_');
define('_DB_PASSWD_', 'prestatheme');
define('_DB_TYPE_', 'MySQL');
define('_COOKIE_KEY_', 'Y9ffbRk0db63owgGnt2XxH7qKt.JY60Tb5WaugzxfUOtoUW0jxv6bRLL');
define('_COOKIE_IV_', 'KoHr2hkb');
define('_PS_VERSION_', '1.0.0.8');

?>

I am not sure what else I can do.

Thanks again.

Yemmi

post_migration.doc

[atyno]

I set up exactly (a) the same databse user names and password as per my old host (

DB_PASSWD = new password

you must enter new password here. not old!

if you created new database with same password, check what is database name. new host can add prefix to database name...

[Paul C]

Yemmi,

It may be that the MySQL host isn't "localhost" for your new hosting company. Some companies use separate database servers from the host that your site is running on - worth checking!

Paul

[Leboeuf]

Paul,

Thank you so much. I appreciate all the feedback received from this Forum.

All is now well with my website - an online pharmacy. Please take a look at http://www.condomsquare.com/

Have a nice weekend.

Yemmi