A fresh start

Today I deleted my blog - not intentionally, it happened. I tried to upgrade MySQL from 5.1 to 5.5, it did not work as expected. I tried varios things and somewhere in between I issued the wrong rm command. I deleted both the backup directory and the tgz of the mysql database directory I made before the update.

After a short heat flash I thought: ok, know I have to import the database again from the SQL dump I have on my Amazon S3. A script copies it there every night. After extracting the tgz from S3 I was shocked that the sql file had a zero byte file size. It turned out that the backup script used an old password for the mysqldump command so it was not able to backup for over a year and I do not have any older backup file.

Read more →