De-Spam your Wiki
1. Backup your database: mysqldump -u root --password wikidb > backup.sql
2. To restore your database:
mysqladmin -u root -p drop wikidb
mysqladmin -u root -p create wikidb
mysql -u root -p wikidb < backup.sql
3. To clean up your database:
mysql -u root -p use wikidb;
DELETE FROM user WHERE user_id > 1; DELETE FROM user_groups WHERE ug_user NOT IN (SELECT user_id FROM user);
DELETE FROM user_properties WHERE up_user NOT IN (SELECT user_id FROM user);
DELETE FROM user_newtalk WHERE user_id NOT IN (SELECT user_id FROM user);
DELETE FROM revision WHERE rev_user > 1 AND rev_user NOT IN (SELECT user_id FROM user);
UPDATE page SET page_latest = 0;
4. on the server:
cd ./maintenance
php ./attachLatest.php --fix
5. in mysql:
DELETE FROM page WHERE page_latest = 0;
6. on the server:
php ./rebuildall.php
php ./purgeOldText.php
DONE!