Maintain your DB backups

Hey all,

As the couple of you have noticed that read this site every year or two i’ve lost a couple of years worth of posts that i am slowly trying to recover out of some fragments of SDI files which is about as painful as it sounds.

Here is what i’ve learned so far:
– Fixing MySQL at 2 am is not recommended
– Schedule (cron) your backups / SQL dumps
– Test your backups at least once every couple of months
– Backup your folder with the SDI files
– Backup before any major version updates (learned this one at 2 am)

I am hopefully recovering a bunch of those posts from the SDI files but its not fun and hopefully they will be recoverd.