Destramic Posted September 22, 2016 Share Posted September 22, 2016 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 Quote Link to comment Share on other sites More sharing options...
requinix Posted September 23, 2016 Share Posted September 23, 2016 Can you unfiddle with the directory? What did you do? Quote Link to comment Share on other sites More sharing options...
Destramic Posted September 24, 2016 Author Share Posted September 24, 2016 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 Quote Link to comment Share on other sites More sharing options...
kicken Posted September 24, 2016 Share Posted September 24, 2016 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/' Quote Link to comment Share on other sites More sharing options...
Destramic Posted September 25, 2016 Author Share Posted September 25, 2016 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.