Bit of a backup theme for this week but remember in my last post I did say I was obssessed with backups! The last post addressed our server-to-server backups, how they work and a nice example of how they can save our collective assess in the event of a 100% data loss meltdown.
But what about your own personal backups? We can of course use our system to restore individual files and databases for you – no problem there but everyone should also have personal backups. Files are easy. If you’re like me you have your sites in folders on your PC/laptop and you edit files there and upload via FTP. So by default you have a copy of your files. But what about databases? A database is written on the server so special considerations have to be made. You can do backups in phpMyAdmin and download them. But who wants to do that weekly, let alone daily? And then download the backups to your computer? I’ve done it all manually and it just sucks. You will definitely forget and that daily backup becomes weekly, then monthly, then quarterly….
Read the rest of this entry »
