Commit Suicide with WordPress. The Killer Database Plugin
Wordpress Suicide Plugin: Clean a WP Database
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
the_guv's sistasite: Setup The Ultimate VPS
"Blank box to top-notch web server"
- plain English copy/paste tutorials with video
- written for VPS beginners and Linux newbies
- perfect for multiple sites, blogs & more
- Fast. Secure. Future-proofed. Cheap-as-chips!
- "Wow!!" "godsend!!" "GREAT!!!" "awesome"
Ubuntu & Debian, Nginx (beats Apache), MySQL, PHP-FPM, Xcache, WordPress, WP MU, Drupal etccccc
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...
... 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.
(I've blanked out this blog's database prefix. Unless you've changed that, which you should for security reasons, they'll say "wp_".)
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 ...
If you liked that ...
-
Video How-to: Install & Configure a WordPress Plugin
One of the great things about the WordPress blog platform is how adaptable it is. Need some special functionality? There's bound to be a plugin - an extension - that will help. This tutorial, complete with [...] -
Video How-to: Backup & Restore a Database with phpMyAdmin
Phpwhatnot? Aargh! Scary? It's not. How often do you backup your mySQL database? Does the idea fill you with horror? Or do you think the "full backup" option at your ISP covers the database too? If the [...] -
Easy-as-you-like! Adapt Square Boxes with Hassle-Free Curves
Give your site a design lift with this simple CSS code snippet. Simply choose a radius and drop it in a div for a real easy way to add curves without any images or javascript. This is super-fast to do and works for [...] -
Maintain Unmanaged VPS - Part 6: Backup a MySQL Database from the Terminal
This guide shows how to save a MySQL database using a terminal, with a simple syntax command. And faster than using phpMyAdmin, for sure. Just replace the db name, username and password and paste the code into your [...] -
Video How-to: 10 Tips To Make WordPress Hack-Proof
Having your blog hacked isn't fun, and the standard WordPress installation is not impermeable. Not only does a hacked blog result in downtime, while you work with your ISP to track the problem and ensure it [...] -
Firefox ScribeFire Plugin for Remote Blogging
So, if this works I'll have published a new post to guvnr.com, remotely, using Firefox's ScribeFire add-on. So, hey. Definitely use that more. Update: So I've been playing with the Firefox ScribeFire plugin [...]
kinai February 8th, 2009 at 1:52 am
just use phpmyadmin
the_guv February 9th, 2009 at 10:57 am
@kinai – sure, phpmyadmin is generally better, Suicide is a last resort. Hmmn, it really is generally not recommended!
the_guv November 24th, 2009 at 10:09 am
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
)