Posted 07 March 2006 - 06:21 PM
Posted 07 March 2006 - 06:28 PM
I was wondering if it's possible to create a script for phpbb that resets the database every 24 hours and only keeps 2 users that I specify and all changes to the forum since the original backup are deleted? If so how would I do this? All help is appreciated!
it's possible to do just about whatever you can imagine ;-). what you'll need to question is what will be feasable to run? i don't have time to delve into the workings of phpBB with you at the moment, but i would recommend running something like this:
create your active DB
create your backup DB
when you run your cron job to restore the backup, just TRUNCATE all your tables in the active copy
then, do a SELECT INTO from your backup to your active DB
hope this helps give you some direction.
also, i'm moving this to the 3rd party scripts section.
Posted 13 March 2006 - 12:08 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users