plan to install new

[superbikecoach]

hi

after a frustrating try to move a working shop from one webhoster to an other, i consider to reinstall and start all over again.

 

before i do this, i want to ask :

- is it possible to redirect the mysql to the existing database (the original/old one), and...

- is this a way to update the 'new' shop with my products?

 

thx in advance

[Dave L]

Moving prestashop to a new host shouldn't be that problematic. What exactly is causing the problem for you?

 

Does the old host and the new host operate on the same management system like cpanel, Plesk etc.

 

Is it a large site with a big database?

 

What version of prestashop are you using? (it may be a good opportunity to upgrade to the latest version as part of the move.

[superbikecoach]

you have no idea... i tried everything i found here!!! i still have postings ongoing.

 

i think i totally messed it up with try and error. right now i can't login on the back office, or database. i please you to take a look yourself. http://shop.superbike-coach.com/chef/index.php

 

i installed an additional shop to see if subdomains and stuff working http://shopusa.superbike-coach.com/, and it does work great.

 

please help!

[Dave L]

Looks like your store cannot connect to your database.

 

Take a look in /config/settings.inc.php and check database location, database name, user name and password.

[superbikecoach]

Looks like your store cannot connect to your database.

 

Take a look in /config/settings.inc.php and check database location, database name, user name and password.

 

yeah... i did this too... back and forth. i am on the end man.

[superbikecoach]

- is it possible to redirect the mysql to the existing database (the original/old one), and...

- is this a way to update the 'new' shop with my products?

[oxyweb]

When you go into phpadmin is your database definately located at 'localhost'. quite often it can be a fully qualified domain e.g. mine is something

 

 

Does that username pvlrtyjh_user1 actually have any privileges to anything on that database?

 

To answer your initial question - if you still have access to the old site (as in full Prestashop Backend access) you could use the Tools > DB Backup section or if that doesn't work then go into phpmyadmin and export the WHOLE database as a .sql file and reimport into a newly created database on the new server. There may be some niggles as yo do this but they can be sorted.

[superbikecoach]

When you go into phpadmin is your database definately located at 'localhost'. quite often it can be a fully qualified domain e.g. mine is something

 

 

Does that username pvlrtyjh_user1 actually have any privileges to anything on that database?

 

To answer your initial question - if you still have access to the old site (as in full Prestashop Backend access) you could use the Tools > DB Backup section or if that doesn't work then go into phpmyadmin and export the WHOLE database as a .sql file and reimport into a newly created database on the new server. There may be some niggles as yo do this but they can be sorted.

 

thx oxyweb

i have a full backup. please help me to make this backup run. i tried it and failed (it end up with a 'Bad SubDomain SQl.' page, even though i was doing exactly the way it is explained).

 

let me know what to do.

 

i installed a fresh shop/database just yesterday:

 

www.booking.superbike-coach.com/

[superbikecoach]

everything is working now.

 

SOLVED

[Scotty501]

Can you share how you fixed this?