Solution:
Open the my.ini file found in the directory where you installed mysql usually “C:\Program Files\MySQL\MySQL Server 5.6\my.ini”
find the line
datadir="C:/Program Files/MySQL/MySQL Server 5.6/Data/"
alter new data directory
datadir="D:/Mysqldata/"
Save the file.
Move/Copy the files to the new disk or new folder location
Start the mysql service.
Test the service, to ensure that all the databases are up, and accessible.
Delete files from the original location, if you copied files instead of moving them.
Open the my.ini file found in the directory where you installed mysql usually “C:\Program Files\MySQL\MySQL Server 5.6\my.ini”
find the line
datadir="C:/Program Files/MySQL/MySQL Server 5.6/Data/"
alter new data directory
datadir="D:/Mysqldata/"
Save the file.
Move/Copy the files to the new disk or new folder location
Start the mysql service.
Test the service, to ensure that all the databases are up, and accessible.
Delete files from the original location, if you copied files instead of moving them.
0 Comments