MySQL instance lost when upgrading to Windows 10

Question

I had a running instance of MySQL 5.6 in my Windows 8.1. After upgrading to Windows 10, such instance is gone, including the Windows service for it.

Server data files are however intact. What would be the best way to recover or re-create the exact same instance (or the most similar) back in Windows 10?

score 6 · Accepted Answer · edited Apr 13 '17 at 12:43

6

You can manually put the service back as follows:

STEP 01) Open the Windows CLI as Administrator

STEP 02) cd C:\Program Files (x86)\MySQL\MySQL 5.6\bin or wherever mysqld.exe resides

STEP 03) Reinstall the service

mysqld --install

That's it.

I have mentioned this before in ServerFault and DBA StackExchange

GIVE IT A TRY !!!

edited Apr 13 '17 at 12:43

Community

1

answered Aug 17 '15 at 17:40

RolandoMySQLDBA

3,215

score 1 · Answer 2 · answered Jul 14 '16 at 08:20

All you need to do is reconfigure your current server. A nice step by step tutorial including screenshots can be found here, you do like this:

First, open the application MySQL Installer – Community and click on Reconfigure
Setup TCP/IP Port Number and Firewall
Check Configure MySQL Server as a Windows Service and also check Start the MySQL Server at System Startup
Apply the server configuration and your done!

score 0 · Answer 3 · answered Jul 13 '16 at 15:02

0

Good advise. Don't forget to link to the correct ini file (if you have changed it)!

https://dev.mysql.com/doc/refman/5.5/en/windows-start-service.html

answered Jul 13 '16 at 15:02

Joost

1

MySQL instance lost when upgrading to Windows 10

3 Answers3