I have a live WordPress website which is based on WooCommerce, now I have another website (uploaded on QA Server) which is updated version of live site, Some extra plugins also installed in it.
Now I have to replace live site with Updated version of it which is uploaded on QA Server, plus I have to save all transactions of live site (so replacing database is not a good option).
What to do?
分享 My favorite tool for migrating WP databases is: WP Migrate DB Pro
But the answer largely depends on what you've updated on the testing site. Using the above plugin you could pull all the database tables except wp_posts and wp_postmeta and that should get you any new options you've configured with your new plugins without overwriting your Orders.
Granted this means you would you not automatically pull in any new pages/posts/products, etc either. But for that could use the Import method described in sanki's answer.
分享
