Expunge non-public content from a WordPress/BuddyPress installation

It’s a common practice to create local WordPress development environments using a copy of the production database. But this can cause problems with a large production site, as the database can become very large, and it is full of non-public information that you may not want to make available to all members of the development team. This is especially problematic when running a plugin like BuddyPress, which allows users to create a great deal of content with various privacy levels.

To work around this problem for the CUNY Academic Commons, I wrote this plugin: cac-database-cleaner. It will remove all non-public data from a WP database, while still leaving an intact database image that can be used to populate a development environment.

WARNING – This is a dangerous tool, as it deletes large amounts of data. Under no circumstances should you install this plugin on a production site. To use: export your production database; import to a separate database and perform any manual changes necessary for the WordPress site to load locally (such as modification of your local hosts file); activate plugin and navigate to Dashboard > Network Admin > CAC Database Cleaner.

Again, do not use this plugin if you don’t know exactly what you’re doing.

Note that plugin support is ideosyncratic to the CUNY Academic Commons, where we run an old version of BuddyPress Docs, an old fork of BuddyPress Group Documents, a plugin called More Privacy Options, legacy bbPress forums, etc. Feel free to modify the plugin to work with whatever other data you’d like.

3 thoughts on “Expunge non-public content from a WordPress/BuddyPress installation

  1. Pingback: Expunge non-public content from a WordPress/BuddyPress installation | The WordPress C(h)ronicle

  2. bb

    Hi buddies, need to get you here. Seems there is a glitch between Divi from Elegant Themes and lates buddypress version 2.0.1. When BuddyPress was install and activated, it shows this message in the browser bar (where the fav/site title are located):

    Warning:Missing argument 2 for bp_modify_page_title()in/home/frostie/public_html/thum-new/wp-content/plugins/buddypress/bp-core/bp-core-filters.php on line 393

    Whilst ET support tried by advising to clear cache which I did but didn’t solve the glitch. How can this be solve please. I’m using buddypress to power online medical community for Nigerians Doctors and here is the link: http://deefrentng.com/thum-new

    Thanks in anitcipation. Cheers


Leave a Reply

Your email address will not be published. Required fields are marked *