How to export PrestaShop(8.2.1) theme with changes made on subdomain to other subdomain?

[prestaKar]

Basically we wanted to upgrade our main website 'site.com' to make it look more modern.
For that we created a subdomen 'test.site.com'
However after I applied changes to theme, I noticed it stores data in mysql.
In conclusion it means if I tried to apply whole theme + files + database, it would break the main website.

To avoid this I created an exact copy of our main website (site.com) on test3.site.com
and now I would like to export the changed theme of test.site.com and apply it to test3.site.com
(To at least merge part of my previous work) And then apply changes so that database won't crash.

I have issue with exporting the theme and changes made to it, as on presta 8.2.1 for test.site.com there is no "export current theme" as opposed to prestashop 8.1.1 (I disabled Edition Basic module to see if it shows up, but in Customization - > Themes there is still no option to export it.)

Perhaps you have idea how I could 'merge' test into test3?
Can I copy CHANGED theme of test to test3?
Or there is no way to avoid conflict and I should redo everything on 1:1 copy of orginal site(I mean test3.site.com here) and then import everything to main domain?

[Prestashop Addict]

Hi, sure you can just copy changed files of theme (js, css, templates, modules...).

[ComGrafPL]

Isnt better to copy data base from test3.site.com to test.site.com? Less issues in my opinion. 

[prestaKar]

Is there a way to copy database in some easy way from one to other? From what I have seen while browsing tables they are pretty much the same, and only thing that comes close is "export the .sql file" which allows me to create and insert values into tables, but there is no "update" replace

 

 

[Knowband Plugins]

If the PrestaShop version and the installed modules list are the same, then you can simply take a backup of the database from one domain (using phpmyadmin etc) & import it on the other server.

If the PrestaShop version is different, then you can copy the theme folders. 

 

 

[prestaKar]

19 hours ago, Knowband Plugins said:

If the PrestaShop version and the installed modules list are the same, then you can simply take a backup of the database from one domain (using phpmyadmin etc) & import it on the other server.

If the PrestaShop version is different, then you can copy the theme folders. 

 

 

The issue is the whole new theme is leotheme, which holds changes made to the theme in the database of test, so i am wondering how to 'merge' databases without selectively browsing tables and replacing them.

[Knowband Plugins]

3 hours ago, prestaKar said:

The issue is the whole new theme is leotheme, which holds changes made to the theme in the database of test, so i am wondering how to 'merge' databases without selectively browsing tables and replacing them.

I don't think it's an easy task to merge 2 databases .