Saturday, June 3, 2017
Change Location of MySQL Data Directory Windows
Change Location of MySQL Data Directory Windows
1. Stop MySQL Service
2. Move Data Directory to desired location
in SQL Server 2012 default location of Data directory is "C:ProgramDataMySQLMySQL Server 5.7Data"
3. Edit my.cnf ( Location of my.cnf is "C:ProgramDataMySQLMySQL Server 5.7"
4. Edit Parameter "datadir= todesireddirectory"
5. Save File
6. Restart MySQL service
