Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a blog on OS X Lion Server with about 750 Entries and would like to export them in order to migrate to a different platform (Confluence).

Although I found a solution to export a Snow Leopard Blog/Wiki to CSV, I couldn't find anything to export the Blog Data of a Lion Server installation.

share|improve this question

There is no ready-made solution for this AFAIK. This article tells how to backup and restore the whole wiki or just a single wiki (or blog?), but the output created by "wikiadmin export" seems to be some binary dump of the database which can be fed only to "wikiadmin import".

The Lion Server Blog/Wiki itself is kept in a Postgres database named "collab", which you can access from the server's command line: sudo -u _postgres psql collab. The table structure seems quite complex, though - I have a test wiki with 2 documents and it still has 67 tables. You might want to try some graphical frontend for Postgres to look through the tables and export those needed.

share|improve this answer
Yep. Snow Leopard used a totally different system which was based on both an sqlite3 database including revisions AND actual html files. In Lion, the wiki was moved into Postgres, aside from attachments, so what Marie says is correct: much more difficult. Until someone tailor-makes an "OSX Wiki Postgres - to - something" utility, you're in for some trouble. Maybe the best bet is to find a CMS that can scrape content from a running web server, and then run it on yours. – username Sep 7 '12 at 20:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.