Moving database to another drive -- Windows 10
Posted by: Ray Yates
Date: July 31, 2017 12:06PM

I'm sure this has been asked and answered many times, but it's not working for me. I detail what I'm doing below. What am I doing wrong?

The problem:
After I move the database to drive, and restart the server, Mysql does not find the database.

Platform: Windows 10: MySql 5.7, Installed used: mysql-installer-community-5.7.19.0.msi

Steps taken:
1. Use Mysql Notifier to stop MySQL57
2. Using file manager, copy "C:\ProgramData\MySQL\MySQL Server 5.7\Data" to E:\MySql\Data
3. Use MySQL Workbench -- Run as Administrator -- Open Local Instance MySQL57
4. Select Server -> Options File
5. Change datadir from C:/ProgramData/MySQL/MySQL Server 5.7/Data to "E:/MYSQL/Data" and apply changes.
6. Close MySQL Workbench and use Use Mysql Notifier to Start MySQL57

Results:
MySQL notifier starts but turns yellow.
MySQL Workbench shows no tables and the server will not start.

Options: ReplyQuote


Subject
Views
Written By
Posted
Moving database to another drive -- Windows 10
291
July 31, 2017 12:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.