The Wetland Wiki, with almost 200 articles was successful for a few years, but writing constant wiki style articles and combating incessant spam was tiring. Combining this with the improving coverage on wetands at Wikipedia, made it time to close the Wiki. Short sightedly, I closed the wiki rather than than maintaining it, leaving me with an dated, unsupported version of Mediawiki, with some good articles residing in the database. Mediawiki offers a bunch of export options, but all I had was the MySQL datbase. What to do? Goto Stackoverflow of course! I Found the following snippet of code to run in phpmyadmin, which extracts the last revision of the page text and title, which can be easily exported to a csv file. The csv still retains the wiki styling, but with a little effort, all page data can be retrieved. The Sql is as follows:
SELECT page_title, page_touched, old_text
FROM revision,page,text
WHERE revision.rev_id=page.page_latest
AND text.old_id=revision.rev_text_id;
The Wetland Wiki was published under the Creative Commons, and the csv file of all of the articles in a semi readable format is is available here: Wetland Wiki extract
