De-Spam your Wiki

From The Datapanic Wiki
Revision as of 10:51, 29 April 2015 by Datapanic (talk | contribs) (Created page with " 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 wik...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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!