I learned a lesson today of
- Dangers of working live
- Dangers of not having regular MySQL Backups
- Dangers of not validating code before it's written
I was creating a tool that would allow me to edit blog posts through the CMS, and with this I ran a MySQL Query containing an
But I forgot to add
WHERE `x`='y' and yeah. It replaced all of my blogs with the properties of one blog post, text, URLs Stubs, HTML. The full lot.
I only have a backup of the first two blog posts, the full post I did about moving the site over to CodeIgniter - that is gone. Shame! It could be much worse, I think if I was running a much larger production then I would have taken steps to avoid it, I knew it was a possibility and it has happened in the past but only on test data.
My current hosting provider doesn't have a tool that allows me to create automatic backups. If I was hosting the site on my own solution then it would make it much easier to 1. work in a developement mode and 2. run automatic backups including SQL dumps and store the data in a secure vault.
Posted on Tue 4 Jul 2017 at 16:45 by gergy (Edited)