View Full Version : Auto database backup
traction
08-17-2005, 11:33 AM
Is there a way to automatically backup the phpBB and coppermine database on a site say twice a week??
After loosing some members on my forum due to me making a mistake with my database it would be good if I could set up an automatic backup.
O.
retrogad
08-17-2005, 04:24 PM
Is there a way to automatically backup the phpBB and coppermine database on a site say twice a week??
After loosing some members on my forum due to me making a mistake with my database it would be good if I could set up an automatic backup.
O.
I wrote my own backup script at one point, but it wasn't complete enough. So I've been using a third-party database backup script to do my own daily MySQL backups. I wouldn't recommend using its TAR abilities, though; it tends to mangle the TAR file after a few days, and a whole set of backups become worthless junk. However, for normal, unpackaged, uncompressed backups, it's a pretty good tool: http://restkultur.ch/personal/wolf/scripts/db_backup/
traction
08-18-2005, 03:17 AM
Did SG install it on the server for you?
O.
bart5986
08-19-2005, 01:07 AM
there's probably a phpbb modification that backs up your database.
retrogad
08-21-2005, 03:30 AM
Did SG install it on the server for you?
O.
Nope, I did it manually. Not too hard to set up, though. Set up the parameters in config.inc.php, add a cron job in cPanel to run the backups however often you like, and badda-boom. Then again, maybe it's just me ;)
But yeah, like Bart said, I imagine there's a phpBB mod out there somewhere that'll handle backups for you. I use a hand-coded forum myself, so I can't tell you where to look for that, sorry.