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 community@magento.com.

Magento Forum

DB Backup without customer/order data. 
 
Paine
Member
 
Total Posts:  73
Joined:  2010-01-25
 

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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
tzyganu
Mentor
 
Avatar
Total Posts:  2205
Joined:  2009-11-18
Bucharest, Romania
 

exclude all the the tables that start with customer_ and sales_
For these tables export only the structure.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top