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? rday