WordPress Suicide Plugin: Clean a WP Database

Suicide's last-chance-to-cancel screen

How do you clean a WordPress database of unwanted data, while retaining user or other select information?

Strip out the database using phpMyAdmin? Sure. But a lazier option? WordPress Suicide.

Suicide allows you, quicky and easily, to:-

  • delete all blog posts
  • delete categories
  • delete comments
  • delete links
  • delete custom fields
  • delete users
  • delete blog settings

Setup Unmanaged VPS (4 Noobs!) ... with vpsBible
Secure WordPress. Properly. ... with wpCop, the platform's dedicated security website
Olly 'the_guv' Connelly's vpsBible.com site and 'WordPress 3 Ultimate Security' book.

How to Use WordPress Suicide

Unzip and upload wp-suicide.php to your plugins directory: /path/to/wordpress/wp-content/plugins

Activate the plugin from within your wp-admin Plugins page

Goto Manage > Suicide for the following screen…

the Suicide options screen

… but Back up your Database First!

Before running Suicide, I strongly advise backing up your entire database. I assume no liability, er, either way! Go careful.

Running Suicide

You did back up your database, didn't you?

OK. Goto Manage > Suicide

By default, a bunch of data is check-marked for deletion. Uncheck the data you want to preserve. Be careful here.

Click the “yes” button and you'll be prompted one last time. This is the last chance to cancel.

Confirmation Screen

Finally, a progress screen let's you know what changes have been made to your database.

This screen also confirms that the plugin has been deactivated, so that you cannot mistakenly use it again.

If you do need it again, guess what, reactivate it!

What have I forgotten? Let me know. Your comments are valued …


About the Author:

Olly Connelly (yeah, that's me) blogs at guvnr.com, polices WordPress security at wpCop.com and helps noobs build web servers at vpsBible.com, so if you've got sleeping problems you know where to come.


  1. the_guv  November 24, 2009

    UPDATE: This plugin may have been disbanded. So hey, you will just have to use phpmyadmin! (You can try Googling for it though, as the developer may have just had a little holiday 😛 )

  2. the_guv  February 9, 2009

    @kinai – sure, phpmyadmin is generally better, Suicide is a last resort. Hmmn, it really is generally not recommended!

  3. kinai  February 8, 2009

    just use phpmyadmin

Add a Comment