All MySQL Databases lost overnight

Posted by Iain on Server Fault See other posts from Server Fault or by Iain
Published on 2012-12-14T10:51:40Z Indexed on 2012/12/14 11:05 UTC
Read the original article Hit count: 145

Filed under:

mysql5.5

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.

Related posts about mysql5.5

How to find out where or if MYSQL5 logs are stored on a machine WHM/Cpanel

as seen on Server Fault - Search for 'Server Fault'
I have a WHM/Cpanel re-seller hosting account on a virtual private server (Linux). I have root access to the machine via SSH I am trying to locate a file that contains information that will help me to determine which users have accessed what db and from which hosts. I would imagine this kind… >>> More
nginx+mysql5 loadtesting configuration strangeness

as seen on Server Fault - Search for 'Server Fault'
i am trying to setup a new server running on debian6 and trying to make it work smooth under load. i ve used a wordpress site as a test object, and tried the configurations on http://blitz.io. when i increase the mysql max_connections from 50 to 200 lots of timeouts start to occur. but on 50 , no… >>> More
Installing mysql on leopard: "Can't connect to local MySQL server through socket"

as seen on Stack Overflow - Search for 'Stack Overflow'
I migrated to a new machine and used migration assistant to copy across my files (which seemed to copy across the DBs) but I had to use macports to install Mysql (whereas last time I compiled from source via Dan Benjamin's guide). For some reason, mysql is intermittently throwing the following error; Can't… >>> More
Failed to link mysql5.1.39\bin\libmySQL.dll in a c++ project

as seen on Stack Overflow - Search for 'Stack Overflow'
When trying to link that library,I get such an error: fatal error LNK1107: invalid or corrupt file: cannot read at 0x2D0 Anyone familiar with this? >>> More
PHP5.3 is not working with MySQL5.1 IIS7 Times out

as seen on Stack Overflow - Search for 'Stack Overflow'
I have set up PHP5.3, MySQL5.1, and IIS7 on Window 7 but php doesn't want to work with MySQL. I'm assuming it is a configuration error or an incomplete install on my part. MySQL5.1 is working PHP5.3 is working, phpinfo() shows info and that i have enabled MySQL IIS is setup and using fastCgiModule… >>> More

Developer IT