Jump to content

mysql datadir config


Destramic

Recommended Posts

hey guys i've fiddled about with my mysql datadir and i've buggered it! what have i done wrong please :

C:\WINDOWS\system32>net start mysql57
The service is starting or stopping.  Please try again later.

so my - my.ini and data folder was in

C:\ProgramData\MySQL\MySQL Server 5.7

i copied all the files/folders into

R:\localhost\mysql

stopped mysql and edited the my.ini inside the C:\ProgramData\MySQL\MySQL Server 5.7 directory.

 

 

edited: under [mysqld]

basedir=R:/localhost/mysql
datadir=R:/localhost/mysql/Data

i have no error log and now i'm completely stuck....i'd like to know how it is done, worst comes to the worst i can just reinstall mysql 5.7 and leave it alone :)

 

thank you

 

 

 

 

Link to comment
Share on other sites

i moved all the data in C:\ProgramData\MySQL\MySQL Server 5.7 to another drive

and tried to config the my.ini  in C:\ProgramData\MySQL\MySQL Server 5.7 so it will read and store data from ther drive

 

i know it can be done but i'm obviously doing something wrong

Link to comment
Share on other sites

Only move the data directory, leave the my.ini file where it is.  Also only update the datadir entry to the new location.  Basedir is supposed to point to where mysql is installed, ie 'C:/Program Files/MySQL/MySQL Server 5.7/'

 

worked a charm thank you kicken :happy-04:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.