Unable to restart mysql after changing the datadir

mysql database windows datadirectory
Suhail Gupta picture Suhail Gupta · Jan 19, 2016 · Viewed 7.5k times · Source

I am unable to restart the server after changing the default datadir from C:/ProgramData/MySQL/MySQL Server 5.7\Data to D:/Data.

  • I changed datadir to datadir="D:/Data"
  • Then I stopped mysql
  • Copied the Data directory to D:/
  • Attempted to restart the server
  • Unable to start

What could be the reason for it?

Error snapshot:

enter image description here

However, it works fine if the original datadir path is restored.

Answer

sski picture sski · Apr 15, 2016

Assign full permissions to the NETWORK SERVICE for D:/Data

Related questions

Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More
How to find the mysql data directory from command line in windows

In linux I could find the mysql installation directory with the command which mysql. But I could not find any in windows. I tried echo %path% and it resulted many paths along with path to mysql bin. I wanted to …

Read More
Where does MySQL store database files on Windows and what are the names of the files?

So I accidentally formatted my hard drive and re-installed Windows and forgot to backup an important database I had in my MySQL server. I'm trying to salvage files now using some software, but I don't know what to look for. …

Read More