Mariane Posted June 13, 2013 Share Posted June 13, 2013 I installed Prestashop following the instructions here: http://doc.prestashop.com/display/PS15/Installing+PrestaShop?utm_source=html_installer Everything went fine until I tried to replace the newly created database with a backup of the database of the old shop. I did not check this backup for integrity, I don't know how to do that. When I try to import the backup via phpmyadmin, I always get error messages of the type "cannot create such a table" or "cannot drop such a table". If I ignore these error messages, the new shop does not function. It says it cannot connect to the database. I noticed that all databases tables in the newly created database are prefixed with ps_, while the tables in the backup are prefixed with prstshp_. What should I do, please? Link to comment Share on other sites More sharing options...
El Patron Posted June 13, 2013 Share Posted June 13, 2013 what version of PS? 1 Link to comment Share on other sites More sharing options...
sadlyblue Posted June 13, 2013 Share Posted June 13, 2013 First of all, if the prefix is different, there's no way they will work. Second, what version did you had? and what version do you have now for prestashop? 1 Link to comment Share on other sites More sharing options...
El Patron Posted June 13, 2013 Share Posted June 13, 2013 you can change the prefix to match your db via config/settings.inc.php basically you want to delete the installed db (back it up first), then import your desired db... change the settings.inc.php then you should be good to go 1 Link to comment Share on other sites More sharing options...
tuk66 Posted June 13, 2013 Share Posted June 13, 2013 I suggest to hire a database specialist. Link to comment Share on other sites More sharing options...
sadlyblue Posted June 13, 2013 Share Posted June 13, 2013 you can change the prefix to match your db via config/settings.inc.php basically you want to delete the installed db (back it up first), then import your desired db... change the settings.inc.php then you should be good to go I agree with you, if the versions are compatible. If the old shop is not 1.5, an expert will be needed, or use an older version of prestashop and then upgrade it. 2 Link to comment Share on other sites More sharing options...
Mariane Posted June 13, 2013 Author Share Posted June 13, 2013 Thank you all. The new shop is 1.5.4.1. I don't know the version of the old one, I only have a backup of its database. I know where it is: http://mahottedeco.com/ but the version number is not displayed on the front page. I will tell the owner to upgrade it to the latest version and then do a new backup. Hopefully this will fix the problem. I'll post again to say if it did it or not. Link to comment Share on other sites More sharing options...
El Patron Posted June 13, 2013 Share Posted June 13, 2013 the version is only displayed in the back office...at the bottom you can look in the configuration table of your db to find the old version.... create a running test shop of the existing shop on your local computer then back that up the use the upgrade options in presashop to move to 1.5.4.1 repeat this (using back up) until you get it right.... then back up production and upgrade it Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now