SQL archiving?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Alphacarbon
Registered User
Posts: 467
Joined: Sun Apr 09, 2006 11:23 pm

SQL archiving?

Post by Alphacarbon » Mon Jan 18, 2010 6:27 am

My SQL database is getting a bit chunky. I was told that PHPBB can archive things and make the database run better (which I'm not sure how that works. would it split old stuff into a different database?). Is that accuate, and is it something I can do from the ACP? Does it affect the running of the site? I would appreciate any help on the matter.

User avatar
calebrw
Registered User
Posts: 679
Joined: Mon May 10, 2004 1:44 am
Location: Minneapolis, Minnesota
Contact:

Re: SQL archiving?

Post by calebrw » Mon Jan 18, 2010 6:30 am

Please provide us with the information necessary to assist you by filling out the Support Request Template.

One thing you can do is prune, which gets rid of topics of meeting certain criteria.
Caleb Williams
My Photography:
http://blog.calebwilliamsphotography.com

Alphacarbon
Registered User
Posts: 467
Joined: Sun Apr 09, 2006 11:23 pm

Re: SQL archiving?

Post by Alphacarbon » Mon Jan 18, 2010 2:02 pm

Ok I will.

Although, before I do that, can someone just tell me if it's possible to break the SQL into smaller manageable parts without affecting the functioning of the forum? What can one do other than pruning? I don't want to lose old topics.

Thanks in advance.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51759
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL archiving?

Post by Brf » Mon Jan 18, 2010 5:30 pm

No. There is not a way to "archive" some posts. All you can do is prune them out.

Alphacarbon
Registered User
Posts: 467
Joined: Sun Apr 09, 2006 11:23 pm

Re: SQL archiving?

Post by Alphacarbon » Mon Jan 18, 2010 5:32 pm

Brf wrote:No. There is not a way to "archive" some posts. All you can do is prune them out.
Ok thank you for your answer. I suppose this makes my other thread redundant (sorry about that).

User avatar
Lumpy Burgertushie
Registered User
Posts: 66471
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: SQL archiving?

Post by Lumpy Burgertushie » Tue Jan 19, 2010 8:47 am

Alphacarbon wrote:
Brf wrote:No. There is not a way to "archive" some posts. All you can do is prune them out.
Ok thank you for your answer. I suppose this makes my other thread redundant (sorry about that).
and pruning means deleteing. that means they are gone forever.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
ChriZathens
Registered User
Posts: 1477
Joined: Tue Apr 18, 2006 9:11 pm
Location: Athens, Greece
Name: Chris

Re: SQL archiving?

Post by ChriZathens » Tue Jan 19, 2010 10:20 am

You can optimize your database... This will decrease the db size a little.

You can also try (Disclaimer: do these kind of stuff on your own risk):
Change In ACP-->Server configuration--> your search backend from fulltext native to fulltext mysql. Then you can drop your old search index and create a new one. The fulltext mysql will not create phpbb_search_wordlist/match tables which right now may be half your db size and your search will work just fine.
My mods in MODDB:
Add Homepage link in header - Change user activity post limit - Post number in viewtopic
If you need support click on the support tab there and post your question.
Do not PM me - chances of viewing my PMs are way thinner than viewing the support question in the customization DB...

Locked

Return to “[3.0.x] Support Forum”