Jump to content

Problems merging sql database


Recommended Posts

Hi All

 

Have built prestashop on a domain.. now that i have added products etc i want to move it onto my main domain.

 

I have installed the back up of the site onto the new domain and then have imported the database. When running through the install i get the attached error. Any thoughts?

post-1310481-0-15980000-1473672911_thumb.png

Link to comment
Share on other sites

As you say, you have installed the back-up onto the new domain, and then imported the database into that installation. So far so good, but weren't you done at that point? Why go into a fresh installation?

 

What you are doing right now is installing vanilla PrestaShop, which is rightfully claiming there already exist tables with prefix ps_ (your imported data, I assume).

Edited by Apium (see edit history)
Link to comment
Share on other sites

As you say, you have installed the back-up onto the new domain, and then imported the database into that installation. So far so good, but weren't you done at that point? Why go into a fresh installation?

 

What you are doing right now is installing vanilla PrestaShop, which is rightfully claiming there already exist tables with prefix ps_ (your imported data, I assume).

 

I went into new installation as when i uploaded the backup files (without the install folder) and attempted to view the site i had an error message saying install was not found. I then added the install folder and end up here.. 

Link to comment
Share on other sites

Could you go back, upload the backup files, and import the database? Then try to go to your admin page, and change the domain name (base url) and all other settings to match your configuration. If you cannot, maybe FTP in (see the link below) and change some of the settings. It could be that you'd have to change some database settings, but I am not too sure about this.

 

Adding an install folder manually to an already configured PrestaShop installation is not the way to go. You might want to read up on https://www.prestashop.com/forums/topic/169435-move-prestashop-to-new-domain/, or similar.

Edited by Apium (see edit history)
Link to comment
Share on other sites

Could you go back, upload the backup files, and import the database? Then try to go to your admin page, and change the domain name (base url) and all other settings to match your configuration. If you cannot, maybe FTP in (see the link below) and change some of the settings. It could be that you'd have to change some database settings, but I am not too sure about this.

 

Adding an install folder manually to an already configured PrestaShop installation is not the way to go. You might want to read up on https://www.prestashop.com/forums/topic/169435-move-prestashop-to-new-domain/, or similar.

 

Ok.. so think i have solved the problem (123-reg duplicating databases) however one final question. when typing the main domain it routes to the other one.. I am sure this is somewhere in the settings but cannot seem to find it..

Link to comment
Share on other sites

  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...