[Imc-alternatives-tech] Clean install of Alt-IMC beta site

[Dave Fregon]

On Thu, 2009-08-20 at 13:39 +1200, strypes wrote:
> Kia ora Dave
> (cc tech list)
> 
> Hope you enjoyed your time out.
> 
> >> I will be doing the migration this week, only got back yesterday from
> the bush, and will do a clean install etc once I get thru a pile of work <<
> 
> According to Jay, Josh seems to think it would be better to clean out
> the spam, rather than install from scratch. Apparently this has to do
> with tweaks that were made to the database. I don't know anything about
> the technical details myself, but can I suggest you and Josh touch base
> by email/ irc/ jabber, and come to consensus on the quickest way to
> proceed?

No problem, from what I saw, we did clear out the spam, still we have a
5gig database! I tried opening it in VI (a text editor) but it chews so
much machine cpu etc doing so it's hard to tell what data is doing it.

I suggest it may be the cache data, so clearing all the cache tables etc
may help, tho from memory we did this :\ I will look again.

> (@ Josh) I'm wondering why this issue arises at all? At the risk of teaching
> grandpa to suck eggs, I would suggest that pieces of the cms not be
> stored in the same database as user content. 

This would take rewriting drupal I would think.

> If in future we migrate
> the site to another cms, we will want to be able to carry across the
> archived content. Surely this is easier to achieve if the cms
> infrastucture and content are kept as separate as possible?

As in different databases?

Not really, it's all in MySQL so a simple script can export data in
whatever format is required, irrespective of if the tables are in the
same database or not .. 

even if you had content in one database, and 'cms stuff' in another,
deleting content would break cross references to it that occur between
the two.

Dave