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: Rob Echlin <rob [ at ] echlin [ dot ] ca>
  • Date: Sat, 1 Apr 2017 04:12:31 +0000 (UTC)
The fact that it's a wiki makes me suspicious that you have pictures or other media.Yes, there is history, but media could make it look trivial.

Rob
      From: Robert P. J. Day <rpjday [ at ] crashcourse [ dot ] ca>
 To: Ottawa Linux Users Group <linux [ at ] lists [ dot ] oclug [ dot ] on [ dot ] ca> 
 Sent: Friday, March 31, 2017 3:51 PM
 Subject: [OCLUG-Tech] need some advice on how to prune my current wiki so i can move it
   

  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
========================================================================

_______________________________________________
Linux mailing list
Linux [ at ] lists [ dot ] oclug [ dot ] on [ dot ] ca
http://oclug.on.ca/mailman/listinfo/linux