How to Change MySQL Data directory location in Windows - MySQL DBA Tutorial

How to Change MySQL Data directory location in Windows


How to Change MySQL Data directory location in Windows explains what steps you need to take to change the data directory for MySQL Server. First of all you will be stopping the MySQL servers by going to Services. Once the MySQL server service is stopped, you will copy the Data directory for MySQL Server to new location.
Go to configuration file my.ini and then update the location for data directory. You will find a line in my.ini datadir=" provide new path for data directory".
After you update and save the my.ini file. Restart the service and test if you are able to create database, create table etc. to make sure everything working fine.


How to Change MySQL Data directory location in Windows