MySQL Forums
Forum List  »  Install & Repo

Modifying the mysql default data location
Posted by: Eric Martin
Date: August 11, 2013 01:21PM

I am trying to alter and move my data directory for MySql.

I found the my.ini file under:

C:\ProgramData\MySQL\MySQL Server 5.6\my.ini

I shut down MySql and then copied over the data directory to my new location.

I only made the following change:

# Path to the database root
#datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data\"
datadir="C:/Backup/databases/MySql/data\"

This directory is a copy of the C:\ProgramData\MySQL\MySQL Server 5.6\data directory.

When I attempt to start the service again, it says it failed to start. I get about 40 messages in the event viewer, most saying it cannot find items.

Here is an example:

The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

InnoDB: Mutexes and rw_locks use Windows interlocked functions

Anyone know what I am doing wrong?

Options: ReplyQuote


Subject
Written By
Posted
Modifying the mysql default data location
August 11, 2013 01:21PM


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.