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

2017-04-02 Thread Alex Pilon
> On Fri, Mar 31, 2017 at 03:51:34PM -0400, Robert P. J. Day wrote: > > i've logged into cpanel for my domain and, via phpmyadmin, So MySQL? On Sat, Apr 01, 2017 at 01:28:50PM -0400, Brenda J. Butler wrote: > I'd be careful of deleting stuff willy-nilly, for fear of causing > dangling foreign k

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

2017-04-01 Thread J C Nash
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 p

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

2017-04-01 Thread Brenda J. Butler
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 hav

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

2017-03-31 Thread Rob Echlin
n 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

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

2017-03-31 Thread Rick Leir
Of course you would do a backup before monkeying with it. Google "mediawiki delete old revisions" to find relevant extensions and features. On March 31, 2017 3:51:34 PM EDT, "Robert P. J. Day" wrote: > > i'm in the process of relocating my domain crashcourse.ca and, >apparently, one of the da

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

2017-03-31 Thread Rick Leir
Robert: You could do a select count (*) from table; for tables you think might be large. Or select * from table limit 2; to see the first two rows of a table and decide how 'heavy' a row is. Mysqlworkbench is good for browsing. And does the wiki have a control panel other than cpanel? Then you

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

2017-03-31 Thread Robert P. J. Day
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 revisi