diff options
| author | http://jmtd.livejournal.com/ <http://jmtd.livejournal.com/@web> | 2010-04-26 15:14:08 +0000 |
|---|---|---|
| committer | Joey Hess <joey@finch.kitenet.net> | 2010-04-26 15:14:08 +0000 |
| commit | 86484c109d30c0062c5a5056f4adf41c0581b5e9 (patch) | |
| tree | fdf3d7c8f7a2dda3162ef1756ff4d09cf5349eed /doc/tips | |
| parent | f49b9e7411bf9748dc81389e14d70cafaa6ded02 (diff) | |
| download | ikiwiki-86484c109d30c0062c5a5056f4adf41c0581b5e9.tar ikiwiki-86484c109d30c0062c5a5056f4adf41c0581b5e9.tar.gz | |
table name for querying the mediawiki mysql db
Diffstat (limited to 'doc/tips')
| -rw-r--r-- | doc/tips/convert_mediawiki_to_ikiwiki.mdwn | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/doc/tips/convert_mediawiki_to_ikiwiki.mdwn b/doc/tips/convert_mediawiki_to_ikiwiki.mdwn index 9719d9a7e..db1a1745c 100644 --- a/doc/tips/convert_mediawiki_to_ikiwiki.mdwn +++ b/doc/tips/convert_mediawiki_to_ikiwiki.mdwn @@ -59,7 +59,13 @@ specific prefix: e.g. `Category:` will be stripped off. ### Querying the database If you have access to the relational database in which your mediawiki data is -stored, it is possible to derive a list of page names from this. +stored, it is possible to derive a list of page names from this. With mediawiki's +MySQL backend, the page table is, appropriately enough, called `table`: + + SELECT page_namespace, page_title FROM page; + +As with the previous method, you will need to do some filtering based on the +namespace. ## Step 2: fetching the page data |