3

I Implemented a MediaWiki site but unfortunately somebody created thousands of pages through thousand of users.

Which query could I run for deleting all pages created by these users except mine?

MediaWiki pages are in wiki_page and wiki_text inside MediaWiki database but there is no field about who created those pages.

Largest table:

  • wiki_text: 682MB
  • wiki_externallinks: 162.5 MB
  • wiki_recentchange: 95 MB

  • wiki_page: 43 MB

    Here, I find a possible answer to my problem but I'm blocked at the first step:

"Export articles created by you (presumably logged in as the WikiSysop user or similar)"

How can I export article made by me if in the table there is no field about user who created pages?

Community
  • 1
Pitone
  • 31
  • 3

1 Answers1

2

If you know some Python (or are not afraid to learn) you should approach this with pywikibot.

You can loop through wiki.allpages() and you can add some logic to decide whether to delete a page or not. Good criteria:

  • Does the page contain specific words? E.g. related to drugs or porn.
  • Does the page have wikilinks to other pages?
  • Does the page have links from other pages?

(I can add a couple of Python lines here if there's any interest. Just let me know.)

the
  • 1,600
  • 1
  • 9
  • 32