MySQL Forums
Forum List  »  Newbie

Re: Database Folder Location
Posted by: Barry Galbraith
Date: October 02, 2014 05:45PM

>I also moved the configuration file to drive E
Did you tell the mysql service that you moved the config file? If not, and you have moved the config file so that the mysql service can't find it, then the service will start with defaults.

So, put the config file back where mysql service expects to find it, and edit it there.
Start -> Run -> services.msc
Find the mysql sevice. Right click, properties.
Read the location of the defaults file.
Also make note of the account that runs MySQL. It's probably NETWORK_SERVICE.

Stop the mysql service.

After you place the my.ini file where mysql expects to find it, open the my.ini file for editing. You might need to do that as Administrator.

Find the entry for datadir.
Copy all the files at that folder location to the new folder where you want your datadir to be.
edit the datadir entry to point to that new location.
save my.ini

Provide read/write/modify premissions for the account that runs MySQL (NETWORK_SERVICE) to that new datadir.

Now start the mysql service.
If it fails to start, you might need to delete the ib_logfile(s) in the new location and try again.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
October 02, 2014 07:00AM
October 02, 2014 11:19AM
Re: Database Folder Location
October 02, 2014 05:45PM


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.