aboutsummaryrefslogtreecommitdiff
path: root/doc/tips
diff options
context:
space:
mode:
authorhttp://jmtd.livejournal.com/ <http://jmtd.livejournal.com/@web>2010-04-26 15:14:08 +0000
committerJoey Hess <joey@finch.kitenet.net>2010-04-26 15:14:08 +0000
commit86484c109d30c0062c5a5056f4adf41c0581b5e9 (patch)
treefdf3d7c8f7a2dda3162ef1756ff4d09cf5349eed /doc/tips
parentf49b9e7411bf9748dc81389e14d70cafaa6ded02 (diff)
downloadikiwiki-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.mdwn8
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