Transferring database between two applications
Development and Programming
Hi all, i have a question. I have build a site couple of years ago. It was a static site. Now the client wants to change the site from static to responsive. I have copied the site to the testing server along with a database. I have used a Foundation 5 framework. Obviously a lot has been changed in order to achieve the new responsive layouts. Scripts and stylesheets has been changed, replaced or removed; and all the template file has been modified too. The entire EE logic however has remain the same. Now, soon i will be ready to launch the new responsive site, but since i have started the development of the new site, content was being added to the old one. The question is, i will need to connect the new site with the old database to make sure that all content is there. What i struggle with is, how much of the data (scripts, stylesheets, snippets, templates etc) is actually embedded in the database.I am simply not sure if when i transfer the DB from old site to the new one all the work done will remain in tact or things like snippets or templates will be replaced with old ones. That would mean that all the work will be gone. My plan is to simply replace all the files of the old application wit the new application being connected to the old DB. Will it work or will i lose my work.
Hope it make sense. Thank you
Regards
:( I have actually tested it right now; i have transferred the database from the old site to the new responsive app and everything has been replaced with the old data. So templates are completely messed up.
Does anyone have an idea how i should play this. Which tables are storing templates, snippets etc? Maybe if i export the database from the old site without this tables than it would work???
Thanks again
Kind regards
Ok guys, seems that i managed to sort this out myself. If anyone has similar issue in the feature; just make sure that before you export database all templates have the “save as a file” ticked. My header file with all css and js files wasn’t saved as a file and this was the reason why after importing that DB my site was messed up. Obviously you need to update the General Configuration and Server path to site’s templates.
Hope it will help someone.
Sorry for troubling
Regards