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

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

  • Subject: [OCLUG-Tech] need some advice on how to prune my current wiki so i can move it
  • From: "Robert P. J. Day" <rpjday [ at ] crashcourse [ dot ] ca>
  • Date: Fri, 31 Mar 2017 15:51:34 -0400 (EDT)
  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

-- 

========================================================================
Robert P. J. Day                                 Ottawa, Ontario, CANADA
                        http://crashcourse.ca

Twitter:                                       http://twitter.com/rpjday
LinkedIn:                               http://ca.linkedin.com/in/rpjday
========================================================================