Jump to content

mysql datadir config


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


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



edited: under [mysqld]


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


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.