Mass Rollback on MediaWiki

Question

So,

I have a personal wiki that I use to document code and programming practices and all that good stuff over at StackOverflow. I linked to one of the pages on an SO answer and BOOM! Spam Bots.

Unfortunately, not being prepared for this causes most of my pages now to be filled with links to sites that I will never bother to click on.

My question is, how can I do a mass rollback, instead of individual rollbacks. For instance, is there a way I can delete all changes made by a particular IP address? Or do I have to individually go through each page and roll them back manually.

Thanks for any help!

Edit: It also looks like the MediaWiki rollback system is also unintuitive. The bots made at least 12 changes to each page, and I can't roll it back 12 changes ago.

Answer 1

You could always just restore your database from your backup, right?

The revert methods on meta.wikimeda.org should work, but as you point out that's not going to fly on a ton of pages.

I would think you could manually go into the MySQL db and purge back to before the spambots, but I'm not sure how that would work.

Answer 2

http://www.mediawiki.org/wiki/Extension:Nuke is an extension that lets you delete all pages created by a user/IP. The JS script mentioned in a comment by Hello71 lets you rollback all changes from a certain user. Used together, it works pretty well.

For your specific case of having 12 changes to each page from multiple bots, I don't know how well that can be handled.