MySQL Dedicated Partition
1.Stop MySQL Service.
2.Move or copy the Data folder onto the dedicated partition, for instance, D:\.
|
For editing the my.ini file, ensure it is saved in ANSI, not in the UTF-8 format. We recommend using a text editor, which will not change the file format after saving. |
3.Edit my.ini file located by default in C:\ProgramData\MySQL\MySQL Server X.X. and search for the datadir string and change the path to the location of the new Data folder, for example, D:\Data. The folder has to be created before altering the my.ini file.
4.The Data folder needs full control by the Network Service. To add required permissions, follow these steps:
a.Right-click the folder and select Properties.
b.In the Properties window, click the Security tab.
c.Click Edit > Add.
d.Type "Network Service" in the Enter the object names and click Check Names. The name should underline, indicating it is recognized. Click OK.
e.With "Network Service" selected, check the box under Allow for Full control.
5.Edit my.ini file located by default in C:\ProgramData\MySQL\MySQL Server X.X. Under [mysqld] search for tmpdir. If missing, add the following line tmpdir = D:/mysqltemp where the mysqltemp is a custom folder. The folder has to be created before altering the my.ini file and needs full control by the Network Service.
6.Start MySQL Service.