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

6 comments:

  1. For example, the US Social Security number. The US Government possesses it-its structure and controls, and the substance doled out per person. ExcelR Data Science Courses

    ReplyDelete
  2. A debt of gratitude is in order for sharing the information, keep doing awesome... I truly delighted in investigating your site. great asset... Fault Location Services Chapel Hills

    ReplyDelete
  3. this is very informative. God bless you bro.

    ReplyDelete
  4. Thanks for giving me the opportunity to talk about a Data science course. For the Best career in Data science, I recommend Skillslash is recognized as the best data science institute in Hyderabad. We cover all the essential topics in data science like R, Python, Machine Learning, and Deep
    Learning, Tableau, etc.

    ReplyDelete