mysql datadir config

[Destramic]

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

 

 

 

 

[requinix]

Can you unfiddle with the directory?

 

What did you do?

[Destramic]

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

[kicken]

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/'

[Destramic]

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