All MySQL Databases lost overnight
After a call from a customer to say that his website is down, I find that MySQL on our RackSpace Cloud Windows 2008 server was not running. I restarted MySQL but got the 'Access denied for user' error in the browser for all websites with MySQL database. When I look in MySql Server 5.5/data there are no folders other than mysql and performance_schema. It appears all the databases and data have been wiped. Does anyone know what might have happened and where the data has gone? To top that I just found this server is missing from our backup service.
ps appears to be after windows update at 4:01 this morning.
Solution 1:
- Contact Rackspace support.. That's what they're there for.
- Do everything they suggest.
- If that doesn't work, try Dan's suggestion of data recovery software.
- Use this as an opportunity for growth and learning.
Always ensure that all your servers are backed up, and test the backups regularly. There's no point in having a backup service if you never actually test that you can restore from it.
Oh, and turn off automatic updates. Only ever do them once you've tested the impact of the update, preferably on another identically configured server.