porting prestashop 1.6 setup from one URL to another location issue?

[wwesps]

Hi All- I had my prestashop setup & running in a specific URL location, lets say, www.abc.com/gtfshop

And so ofcoz, I had my adminYYYY located at: www.abc.com/gtfshop/adminYYYY

 

Now, that testing is complete, I wanted to move the shop to, lets say: www.gtfshop.com

 

Hosting I use is godaddy.

 

Here is what I did:-

1. Backed up entire contents of directory 'gtfshop' from: www.abc.com/gtfshop

2. Backed up the .sql database using godaddy option. That means, I have the actual gtfshop.sql file

3. I have successfully moved all contents to: www.gtfshop.com but it shows : 500 Server Error

 

Issues:-

 

1. Loading www.gtfshop.com shows 500 Server Error

2. Loading www.gtfshop/adminYYYY can't find the .sql DB and shows below error.

 

Link to database cannot be established: Unknown MySQL server host 'gtfdb.db.9801018.hostedresource.com' (2)
at line 47 in file classes/db/DbMySQLi.php

 

Please help me resolve this issue

 

Thanks,

Vick

[wwesps]

Dear All- Can someone guide (or) give some pointers here? This is a bit urgent as now I can't even logon to my Admin Dashboard :-(

 

BTW, now that my Prestashop url location is changing , does that mean I should re-install Prestashop again on this new URL location ??

 

Thanks,
Vick

[Dh42]

In your config/settings.inc.php file the database is not pointing to the database on the server. The errors are happening because prestashop cannot find the database.

[wwesps]

Hi Dh42,

 

Thanks for pointing to it. 

I see the following:

 

define('_DB_SERVER_','mydbname.db.xxxxxxx.hostedresource.com');

 

The dbname is still the same as: mydbname.db

 

Question is what should be my xxxxxxx value. 

 

I will try to figure out & let you know if making the change worked or not for me

 

Thanks,

Vick

[wwesps]

Ok, I spoke to the hosting customer service & got the _DB_SERVER settings updated. 
Now, have to wait for 24-48hrs until it gets updated & website goes live.

 

Thanks,