MySQL Forums
Forum List  »  Install & Repo

Re: Can't move datadir on MySQL for Windows
Posted by: Barry Galbraith
Date: May 19, 2017 08:36PM

The key here is that the MySQL process is owned by user "Network Service" by default.

Stop MySQL service.

Edit my.ini to point datadir to the new location.

Make sure you have the correct my.ini file that MySQL service is actually using by checking the properties of the MySQL service. It will show you the defaults-file location.

Copy the contents of the original \datadir to the new location.
Set the permissions for the new \datadir to allow NETWORK SERVICE full read/write permission.
Start the service.
When you confirm that the move is successful, you can delete the old \datadir

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can't move datadir on MySQL for Windows
May 19, 2017 08:36PM


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.