Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email firstname.lastname@example.org.
Long story short, we need to setup an off-site “beta site” for testing various things (new themes, extensions, etc). Management has ok’d this with one caveat, customer and order data cannot go on the test server.
Which tables can we exclude from the SQL dump to remove all order and customer data but maintain and preserve a functional install.
Can we just export the DB less the sales_ and customer_ tables and magento will still work?