Is it possible to use separate database?

@amityweb This is something we are already working on.

Can you let me know which plugin you used that deleted all your woocommerce orders?

Usually for plugins which are using the regular wordpress database api such operation should not be possible at all. So I assume in your case the woocommerce plugin ignored the wordpress table prefix and selected all tables instead. Nothing which would help you now, but at least I can warn other users before they are using the same plugin.

first off Rene, thanks for the work, such a huge awesome plugin!

i thought i had read on the main page that it would create a copy of the databases, but when i looked at my phpMyAdmin i saw the same three as before. My issue is similar to the OP, thus why i replied here.

i am troubleshooting a woocommerce issue, and after having tried everything, i need to delete the woocommerce tables and then reinstall woocommerce and it will reinstall the tables as well. I just wondered if you had any advice for the easiest way to do this – maybe involving this plugin? Aside from manually duplicating tables, editing code to point to those, etc..

Either way it and you already saved me lots of time ??

and also – if i was to delete Woocommerce, for example – a plugin which uses the database -if asks “Are you sure you want to remove this and all of its data?” I pressed no because if it’s using the same database data as the original non-staging site, would it remove that data?

Hi Benjamin,

I am troubleshooting a woocommerce issue, and after having tried everything, i need to delete the woocommerce tables and then reinstall woocommerce and it will reinstall the tables as well. I just wondered if you had any advice for the easiest way to do this – maybe involving this plugin?

Check if woocommerce has an option to uninstall everything when the plugin is removed. Most popular plugins have such an option.

> and also – if i was to delete Woocommerce, for example – a plugin which uses the database -if asks “Are you sure you want to remove this and all of its data?” I pressed no because if it’s using the same database data as the original non-staging site, would it remove that data?

Usually, this has nothing to do with the “same” database. WP Staging is using prefixed database tables which are independent from the live system so any operation on the staging site should never affects the live site.

But If a WordPress plugin ignores that it would theoretically be possible to wipe out the live data. I have no confirmed case where that ever happened, though. Even the author of this ticket never replied to my question which plugin he was using so I can only assume that he was working on the live site instead of the staging site and did not notice that but I can not say that for sure.

Best would be to ask woocommerce support if there is an option to reset woocommerce data.