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: "Brenda J. Butler" <bjb [ at ] sourcerer [ dot ] ca>
  • Date: Sat, 1 Apr 2017 13:28:50 -0400
Maybe I missed it in your description, but what tech is the wiki based on?
Worpress, or something else?

I'd be careful of deleting stuff willy-nilly, for fear of causing
dangling foreign keys (or whatever the term is when you delete something
that another table references).

Of course, if you have that backup copy of the DB, you can always put the
original back and start over.  But I'd be more inclined to study the
DB schema before trying to delete anything.  Or, use a wiki API if one
exists to do the deletes.  It may just move stuff over to an archive
table, but then it might be easier to identify what to actually delete
and you can do it properly, deleting the content and the references
to it.

But it seems I always seem to look for doing things the hard way ; -(


On Fri, Mar 31, 2017 at 03:51:34PM -0400, 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
> -- 
> ========================================================================
> 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
---end quoted text---