Prayer Request Forum = Broken

**Shogun** · 11-01-2010, 09:00 PM

Quote:

Originally Posted by DaFace

Thanks for the input. As I've alluded to, I'm really just a wannabe when it comes to this stuff and have no real decision-making authority, but I'm sure that Kyle will stop by eventually and see this. I've thought about the "archive" thing, and it's a possibility if we could figure out how to make it work. Or we may just throw more hardware at it. Who knows?

My website Runs Vbull, and Archives are definitely the way to go

**DaFace** · 11-01-2010, 09:05 PM

Quote:

Originally Posted by Shogun

My website Runs Vbull, and Archives are definitely the way to go

Do you have some nifty way of doing it, or just manually move tables over every once in a while? It seems like it'd be a pain, but it's possible.

**Shogun** · 11-01-2010, 09:09 PM

Quote:

Originally Posted by DaFace

Do you have some nifty way of doing it, or just manually move tables over every once in a while? It seems like it'd be a pain, but it's possible.

I personally move tables over constantly. Our other owner does other things, I'll ask him, but it definitely helps.

DRU · 11-02-2010, 07:49 AM

Quote:

Originally Posted by DaFace

Do you have some nifty way of doing it, or just manually move tables over every once in a while? It seems like it'd be a pain, but it's possible.

There are plenty of nifty ways of doing it. You (or somebody like myself) could write PHP scripts to move all records in 1 MySQL DB to another if they're older than a given date. That would completely automate the process. Could even provide logs of all the stuff that was archived and keep a sticky in the forum somewhere that shows people updates on archived threads.

Another thing you could do is use a tool like Navicat, a MySQL manager, and setup automated backup/archive rules within it. It'd still be automatic but it would run from a client instead of the server.