Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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 blocket 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?

share|improve this question
In the link you posted there is a description on how to manually delete all pages not created by you. (webmasters.stackexchange.com/a/45486/27664) –  user555 May 5 '13 at 22:53
ok, so i have to run: "DELETE FROM revision WHERE rev_user != YOUR_USER_ID;" for revision page, then work on "page_latest" table and last use purgeOldText.php script for delete from wiki_text table. –  Pitone May 7 '13 at 17:42
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.