You are here

Forum Topic Pruning: SOS needs your help

For current or would-be users of Apple Mac computers, with answers to many FAQs.

Re: Forum Topic Pruning: SOS needs your help

Postby Martin Walker » Sun May 10, 2020 7:33 pm

ManFromGlass wrote:OK I take back my post, Martin. Prune away at WA. I’ll count on the SOS hive mind to continue with witty and some downright funny associations!
Am I asking too much??
:headbang:

No you're not asking too much - I'm sure the hive mind will continue to keep this thread alive.

If we honestly thought that anyone would wade through all 1171 pages of this thread it might be worth keeping it all, but I seriously doubt that this will happen ;)

It might be worth hanging on to the most recent few months, but not every word since October 2012 :beamup:


Martin
User avatar
Martin Walker
Moderator
Posts: 15658
Joined: Wed Jan 13, 2010 9:44 am
Location: Cornwall, UK

Re: Forum Topic Pruning: SOS needs your help

Postby Folderol » Sun May 10, 2020 8:29 pm

John Willett wrote:
Martin Walker wrote:
ConcertinaChap wrote:
BJG145 wrote:Couldn't you just archive the Word Association thread instead?

Fair point.

I've already had a request from a regular forum user not to prune that one :headbang:


Martin

Maybe we could just delete the existing thread and start a new Word Association Thread with the last post of the old thread as the first of the new one.

How many people read old posts in that thread? It is just making it go forward that we want. :mrgreen:

Laugh if you like, but if I'm feeling a bit MEH two topics I do have a browse through are the word association one and the make up a lie one. Between them they brighten me up no end.
User avatar
Folderol
Jedi Poster
Posts: 10597
Joined: Sat Nov 15, 2008 1:00 am
Location: The Mudway Towns, UK
Yes. I am that Linux nut.
Onwards and... err... sideways!

Re: Forum Topic Pruning: SOS needs your help

Postby blinddrew » Sun May 10, 2020 11:00 pm

But it would give us the opportunity to make all the same old jokes again.
User avatar
blinddrew
Jedi Poster
Posts: 10208
Joined: Sun Jul 05, 2015 12:00 am
Location: York
Ignore the post count, I have no idea what I'm doing...

Re: Forum Topic Pruning: SOS needs your help

Postby zenguitar » Sun May 10, 2020 11:38 pm

blinddrew wrote:But it would give us the opportunity to make all the same old jokes again.
Whilst neatly side-stepping plagiarism accusations.

Andy :beamup:
User avatar
zenguitar
Moderator
Posts: 9915
Joined: Thu Dec 05, 2002 1:00 am
Location: Devon
When you see a fork in the road, take it.
Yogi Berra

Re: Forum Topic Pruning: SOS needs your help

Postby Dave B » Mon May 11, 2020 8:03 am

Whilst I understand the need for the pruning, do we need to do that on the User Reviews forum? I would have thought that this was an area with almost no duplication and worthy of saving for posterity..
User avatar
Dave B
Jedi Poster
Posts: 5486
Joined: Thu Apr 03, 2003 12:00 am
Location: Maidenhead
Veni, Vidi, Aesculi (I came, I saw, I conkered)

Re: Forum Topic Pruning: SOS needs your help

Postby Forum Admin » Mon May 11, 2020 10:07 am

Dave B wrote:Whilst I understand the need for the pruning, do we need to do that on the User Reviews forum? I would have thought that this was an area with almost no duplication and worthy of saving for posterity..

Yes, I had already pegged User Reviews as a "keep all" scenario.
User avatar
Forum Admin
Moderator
Posts: 3298
Joined: Mon Jul 21, 2003 11:00 pm
Location: A studio deep in the fenlands of Cambridgeshire, UK
SEARCH 11,258 SOS Reviews/Techniques articles: www.soundonsound.com/search

Re: Forum Topic Pruning: SOS needs your help

Postby Cool4music » Fri May 15, 2020 2:45 pm

I'm interested to sign up.

However, is it not easier to delete any records prior to the said date from the database itself? I have worked as a dba and can assist on that activity (once the backup has been done.
Cool4music
Posts: 2
Joined: Fri Oct 17, 2003 12:00 am
Location: London

Re: Forum Topic Pruning: SOS needs your help

Postby Forum Admin » Fri May 15, 2020 3:03 pm

Cool4music wrote:However, is it not easier to delete any records prior to the said date from the database itself?

Thanks for your kind offer, and that is precisely how our tech team will prune the database.
User avatar
Forum Admin
Moderator
Posts: 3298
Joined: Mon Jul 21, 2003 11:00 pm
Location: A studio deep in the fenlands of Cambridgeshire, UK
SEARCH 11,258 SOS Reviews/Techniques articles: www.soundonsound.com/search

Re: Forum Topic Pruning: SOS needs your help

Postby cyrano.mac » Fri May 15, 2020 10:25 pm

Forum Admin wrote:Hi Desmond,

We plan to take a full database backup prior to pruning and store it offline.

As to a text-dump, I've been told it's not a simple task since phpBB pulls in who posted, etc from our CMS user base, and it'll require our web team to spend expensive time to achieve this. That's time we don't have at present with all our other pressing projects and we urgently need to lighten the server load or we may find ourselves with patches of 'dark time', temporary Forum suspension, or any other undesirable scenario -- and commercially, that simply can't happen.

So the proposed solution is the optimal one.


I use Site Sucker...

https://ricks-apps.com/osx/sitesucker/

Makes a copy of the threads you want to remove, so you can post those as static html.

Takes some time, of course. I once downloaded an entire forum like this one, but a little bigger. Took about a week. Site Sucker can adjust links to fit the new root of the site.

Some forum software has a built-in archival function. PhpBB still doesn't have that?
cyrano.mac
Regular
Posts: 108
Joined: Sun Jun 02, 2019 5:00 pm

Previous