Mobile app version of vmapp.org
Login or Join
Odierno851

: MediaWiki spam, deleting last days 2 days ago I did the mistake of updating my MediaWiki site, without transfering my old user management plugin. My site was shut down from my host for mail

@Odierno851

Posted in: #Mediawiki #Spam

2 days ago I did the mistake of updating my MediaWiki site, without transfering my old user management plugin.

My site was shut down from my host for mail spam and there are now over 14 million new pages and so many users that i can't go through and delete them by hand.

I tried using the Nuke extention, but after deleting 150000 items it cant do pattern search, giving the error "There are no new pages in recent changes."

Is there a way to delete all new pages and users created within x number of days or by filtering the Nuke extention by date?

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Odierno851

1 Comments

Sorted by latest first Latest Oldest Best

 

@BetL925

See the comments, but if you're set on this solution you can use deleteBatch.php.

Assuming the timing of the attack is what you said, it would be something like:

mysql -e "select page_title from page where page_touched between 20150319000000 and 20150322000000 into outfile '/tmp/pagelist.csv'"
php maintenance/deleteBatch.php --conf LocalSettings.php -r "Mass deletion of spam attack pages." /tmp/pagelist.csv

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme