This weekend, I updated a Windows 8 workstation to Windows 8.1. This was a development workstation that had a locally hosted MySQL 5.6 instance used for web development work.
After the update finished running, I discovered that the MySQL service was not started... and not only that, the service was completely gone. It no longer appeared in the "services" list.
All the binaries were still present where expected at C:\Program Files\MySQL\MySQL Server 5.6\bin
, but the C:\Program Files\MySQL\MySQL Server 5.6\data
folder looked suspiciously small... the ibdata1 file was less than 100 megs, and this workstation had gigs of data in it's InnoDB database tables.
Sure enough, once I manually fired up the MySQL server, it appeared to have been reset to a fresh MySQL installation. No data besides default databases (i.e., mysql, information_schema, performance_schema), and the only user was "root" with no password.
My first thought was to roll back to a system restore point prior to the update, but unfortunately it appears that System Restore was either off, or all the restore points were wiped out by the 8.1 upgrade.
I'm at a loss as to what would cause this. It's like the Windows 8.1 upgrade "reset" the MySQL installation. I've got the service installed and running again, but what about all the data? Is it just gone? It would have been nice to have a warning. Maybe this post will be nothing but a warning to others (obligatory reference), but I'm still hoping somebody can give me a clue how to recover my data...