home | list info | list archive | date index | thread index

Re: [OCLUG-Tech] need some advice on how to prune my current wiki so i can move it

  • Subject: Re: [OCLUG-Tech] need some advice on how to prune my current wiki so i can move it
  • From: J C Nash <profjcnash [ at ] gmail [ dot ] com>
  • Date: Sat, 1 Apr 2017 13:45:05 -0400
Some years ago I set up several wikis with Mediawiki, which uses SQL etc.
underneath. Later I discovered Dokuwiki which doesn't use a database. There
is some loss of functionality of course, but the whole structure can be just
copied or tarballed and reset elsewhere, and it is relatively easy to prune.
Note that you don't have to separately stop the site and save the SQL, then
save the wiki code etc.

Clearly if you need the SQL support, this is an unhelpful suggestion. If,
on the other hand, the simpler setup will work for you, I recall using
some sort of tool to do the transition and it wasn't a horror to do.
(This was around 2007-8 period.) Google suggests there are some conversion
tools out there.

Best, JN

On 2017-03-31 03:51 PM, Robert P. J. Day wrote:

  i'm in the process of relocating my domain crashcourse.ca and,
apparently, one of the databases (the one for my wiki) has gotten
monstrously large, i'm assuming because of all the history, so that's
it's now over 10G. most of that is just history and i have no interest
in keeping previous revisions, just the current pages.

  i've logged into cpanel for my domain and, via phpmyadmin, i can see
all of the tables in the wiki database ... i'm wondering which of all
these tables i can just scrap to drag down the size of the underlying
SQL database without losing just the current pages.

  i suspect i haven't specified all the info necessary to get a
meaningful answer to this, so any guidance would be appreciated. where
should i start?