How to export WooCommerce orders from database

Hi guys,

I have recently created a copy of my e-commerce site onto a subdomain so that i can improve/update it using a new theme etc. I also created a new database and imported all the data from my live database into the test environment.

The new site is now ready, however since I imported the data from the live database, we have received new orders and customer info, which means the database I am using for the test site does is not up to date with the new orders Make sense?

What i would like to know is how to export just the woocommerce orders and load them into the newly created database so that when I launch the new site, everything is up to date. Would I also need to export anything else that is related to woocommerce?

I hope I’ve made sense there!

Cheers
Antonio