[Mediawiki-l] Upgrade Question

Frank Ralf Frank.Ralf at gmx.net
Tue Oct 26 15:21:29 UTC 2010

> If I went with phpMyAdmin for direct manipulation of the database tables
> what table specifically would contain the information I need?
RTFM (Read the fine manual):

"The page table can be considered the "core of the wiki". Each page in a MediaWiki installation has an entry here which identifies it by title and contains some essential metadata."

"The text of the page itself is stored in the text table. To retrieve the text of an article, MediaWiki first searches for page_title in this table. Then, page_latest is used to search the revision table for rev_id, and rev_text_id is obtained in the process. The value obtained for rev_text_id is used to search for old_id in the text table to retrieve the text."

More information about the MediaWiki-l mailing list