xbmc.org website recovery

I don't think that is that useful. If you find some important post of you is missing, you can grab the cache info and repost.
That will do and will not put into trouble the administrators.

Hi,
I administrate a similarly sized forum (less visitors but over half a million posts) and I run full backup every day and keep a few days worth of binary log (hourly rotated to avoid corruption). Very simple to setup and very effective, the daily snapshot takes a couple of minutes and nobody notices anything (the forum continues to work as is without any issues, the database guarantees data integrity for the exact moment where the dump has started)
With these backups and almost a week's worth of binary logs I can rollback to any point in time in the past week and can easily recover after a major crash.
Additionally - daily dumps are compressed and copied to an off site storage server so even if my server burns and turns to dust, in my worst case scenario I have lost a day's worth of data (I don't replicate the binary logs).

If you need help setting up a similar mechanism - just drop me a note.

gibsonlp Wrote:Hi,
I administrate a similarly sized forum (less visitors but over half a million posts) and I run full backup every day and keep a few days worth of binary log (hourly rotated to avoid corruption). Very simple to setup and very effective, the daily snapshot takes a couple of minutes and nobody notices anything (the forum continues to work as is without any issues, the database guarantees data integrity for the exact moment where the dump has started)
With these backups and almost a week's worth of binary logs I can rollback to any point in time in the past week and can easily recover after a major crash.
Additionally - daily dumps are compressed and copied to an off site storage server so even if my server burns and turns to dust, in my worst case scenario I have lost a day's worth of data (I don't replicate the binary logs).

If you need help setting up a similar mechanism - just drop me a note.

Great Idea !
I assumed xbmc.org did a backup a few times per day, at least !
It's hard to imagine how much data was lost in 1 month.

I would be very interested in how to backup mysql regularly. I have read about scripting mysqldump but not really implemented it outside a test site.

I administer a popular forum and backup once every 2 weeks manually at the moment using phpmyadmin.

I've also seen phpmybackup, but not used it myself yet.

Now I understand why i could not log in... and why needed to register again!

zag2me Wrote:I would be very interested in how to backup mysql regularly. I have read about scripting mysqldump but not really implemented it outside a test site.

I administer a popular forum and backup once every 2 weeks manually at the moment using phpmyadmin.

I've also seen phpmybackup, but not used it myself yet.

Mysqlsdumper. A great tool for DB backup with cron support. (multilingual)

http://www.youtube.com/watch?v=ymjO8OG7R...dded#at=71
Download:
http://forum.mysqldumper.de/downloads.php?cat=2

In the spirit of Community, would xbmc.org share what is the new Backup and Recovery Plan ? Many users here are probably experts in the area of backup and recovery and would happily suggest pluses and minuses of the new backup methods. It certainly could help avoid future data loss.