Incremental backup (archiving )

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
Silverion
Registered User
Posts: 86
Joined: Mon Aug 06, 2001 7:37 pm
Contact:

Incremental backup (archiving )

Post by Silverion »

Hi all we have problem on our board that it grow too big and is killing server, what we wished to do is to install read only version of pbpbb where people will still be able to search for old topics but that will be separated from working version that will keep only last week or two of posts.

To do so i need some way to copy / archive all posts that are older of 2 weeks to (read only) archive version. im interestd if anyone have done something similar or have made some program that can be used in cron table or from admin panel to do this "archiving" also i will be interested to all info that can help to lower load on database.

thanks !!

info about board
Our users have posted a total of 1059030 articles
We have 60885 registered users
The newest registered user is Dylboy
In total there are 219 users online :: 181 Registered, 14 Hidden and 24 Guests [ Administrator ] [ Moderator ]
Most users ever online was 686 on Sat Feb 05, 2005 13:08
Silverion
unofficial Beta tester ;-)

P.S. Sorry for my far from perfect english im italian ...

http://www.tip.it
http://www.arenascape.net/ ARENAscape MUD like browser text game im developing ..

flogger12
Registered User
Posts: 14936
Joined: Tue Nov 25, 2003 2:13 am

Post by flogger12 »

check the MODs section here ( button at the top of page ) and at phpbbhacks.com for a MOD that will automatically archive for you.


robert

User avatar
Silverion
Registered User
Posts: 86
Joined: Mon Aug 06, 2001 7:37 pm
Contact:

Post by Silverion »

thanks robert i tryed to search both but i was unable to find anything that do incremental backup (archive) all i found is one mod that backup entire database and that was not good for me as i wish to archive messages and then autoprune and remove them from working board and keep only in archive board ...

probably it will be enough to execute some mysql commands in phpmyadmin ? but i dont know what tables i need to update new records etc ...
Silverion
unofficial Beta tester ;-)

P.S. Sorry for my far from perfect english im italian ...

http://www.tip.it
http://www.arenascape.net/ ARENAscape MUD like browser text game im developing ..

Locked

Return to “2.0.x Support Forum”