Is it possible to export certain changes to the live domain?

Question: Is it possible to export certain changes to the live domain?
For example theme files, CSS changes or pages?

Answer: There is no automatic mode which detects changes so you will need to exclude/include relevant database tables/folders on
​ your own.

​So, for example, you can say that you want to push only the theme files or the files of a particular plugin.

​You can also say that you want to push the tables _posts, _postmeta only but you can not specify certain individual posts or pages.

​When you copy over the table _posts you will overwrite the entire _posts table.

​This “can” lead to an issue if you want to push a theme created by a page builder and you have created new posts on the live site after creating the staging site. Page builders store all their layout data in these tables as well. So when you are going to copy over the theme including layout structure you will also overwrite all new posts which do not exist on the staging site.

​In that case, we recommend to export/import/create new posts on the staging site as well before the staging site is pushed to live.

Updated on August 30, 2019