We all know how important it is to backup our servers and personal computers… but we all avoid doing it!! We just went through a major crisis in our servers and for some hours we thought we had lost all the info in them… and our last backup of the databases was a few weeks old!! The rest of the content of the server was recoverable (one of the many good things of using CVS is that you keep many copies of the code in different computers), but the databases are critical.
In the end we managed to solve the problem and everything is up and running now, with no data loss. But as you can imagine we are now setting up a backup system for our MySQL databases. Here’s how we did it, in case it may be helpful for anyone.
Read the rest of this entry »