A junior web developer broke all our sites using the root account on our Turnkey WordPress install on the TurnkeyHub - no problem I thought I can just roll back to a back up using tklbam-restore 1.
However after trying 5 different back ups we were getting various different MYSQL errors such as:
ERROR 1005 (HY000) at line 166: Can't create table
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql
errno 32 broken pipe
Once I had tracked down the issue which was that they had changed the MySQL directory permissions why didn't full restores change these permissions back?
I have used both vps.net and linode before and you can power down the instance, restore a back up and be up and running again EXACTLY like you were within 3 mins max!