CODEWITHSUNDEEP
wikimediawiki
Paradius
Paradius

Reputation: 8159

Where do Wikis using MediaWiki Software Store Their Articles?

Where and how do wikis that use the MediaWiki software store their articles?

Upvotes: 3

Views: 2500

Answers (3)

ZA.
ZA.

Reputation: 10477

select * from page 
left join revision on page_id=rev_page
left join text on rev_text_id =old_id 
limit 100;

This sql-query shows which table and how MediaWiki software store their articles.

Upvotes: 1

Reed Hedges
Reed Hedges

Reputation: 1650

In a MySQL database. I've tried using PostgreSQL but encountered a Mediawiki bug in searching text.

Upvotes: 0

Jonik
Jonik

Reputation: 81751

In a MySQL database, typically.

Nowadays MediaWiki also supports other databases, such as PostgreSQL. For details, read the "Database server" section here.

Edit: as to how MediaWiki stores the articles, see Manual:Database layout for much details, such as a diagram of the database schema and the SQL for creating the tables.

Upvotes: 11

Related Questions