Davie Smith Posted June 5, 2011 Share Posted June 5, 2011 I have just purchased a Theme from TemplateMonster which contains a dump.sql file that MUST be imported into the my-sql database in order for the theme to display properly. I am about to upgrade to 1.4.2.5 and don't want to lose all of my existing products. Should I import the dump.sql file after upgrading? Will this overwrite my products on the database?Any help or advice will be greatly appreciated.David. Link to comment Share on other sites More sharing options...
shokinro Posted June 5, 2011 Share Posted June 5, 2011 First you need to confirm the theme compatible with 1.4.2.5, even I don't think there is much changes on the theme.As for the dump.sql, it depends what kind of changes it make to the database. You can open the dump.sql to see what tables it changes. It changes table does not related to PS, then it should be OK.If it is small file, you can attached it to this forum so that someone could give you some advice. Link to comment Share on other sites More sharing options...
Davie Smith Posted June 5, 2011 Author Share Posted June 5, 2011 Thank you for your fast response.I have attached the file as it is only 355KB... Again, if you or anyone else can advise me on what to do I would be delighted.Regards,David. Link to comment Share on other sites More sharing options...
shokinro Posted June 5, 2011 Share Posted June 5, 2011 I can not find the sql file in attachment.maybe you need to change the file extension to something else instead of sql. Link to comment Share on other sites More sharing options...
Davie Smith Posted June 5, 2011 Author Share Posted June 5, 2011 Hi Shokinro,I thought there was an issue with that!I have renamed the file as dump-sql.txt so that you should be able to access it now. dump-sql.txt Link to comment Share on other sites More sharing options...
shokinro Posted June 5, 2011 Share Posted June 5, 2011 I just check the sql file. It drop PrestaShop tables like category. I think it is dangerous to run this script. I will empty those tables and populates the default data.It also empty configuration and re-populate with default data. DROP TABLE IF EXISTS `ps_configuration`; CREATE TABLE `ps_configuration` ( Also it will change back the old database table structures if there is any changes made the your upgrade.(I didn't compare the tables structures, because it will take me some time) Link to comment Share on other sites More sharing options...
Davie Smith Posted June 5, 2011 Author Share Posted June 5, 2011 Hi Shokinro,Is there any advice you could give me to avoid losing all products etc whilst being able to use my newly prchased theme at £102? Link to comment Share on other sites More sharing options...
shokinro Posted June 5, 2011 Share Posted June 5, 2011 Usually the theme should not depend on the database structure, as long as it compatible with 1.4x.So you can have try to use it without running the dump.sql, just copy the theme to the themes folder and install from your back office. But I can not guarantee it 100% work. Link to comment Share on other sites More sharing options...
Davie Smith Posted June 5, 2011 Author Share Posted June 5, 2011 Thank you for your help thus far Shokinro.I will do my best to configure it without the dump.sql file. I guess I will have to take it up with Template Monster if there are issues.Take care. Link to comment Share on other sites More sharing options...
shokinro Posted June 5, 2011 Share Posted June 5, 2011 You are welcome and have a good luck. 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