MySQL Dedicated Partition

1.Stop MySQL Service.

2.Move or copy the Data folder onto the dedicated partition i.e. D:\.


warning

For editing my.ini file, please make sure it is saved in ANSI, not in UTF-8 format. We recommend using Notepad++ that will not change the file format after save.

3.Edit my.ini file located by default in C:\ProgramData\MySQL\MySQL Server X.X. and search for the '# Path to the database root' 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 has to be accessible by the Network Service. To add required permissions, follow these steps:

a.Go to Start > Administrative Tools > Computer Management > System Tools > Local Users and Groups > Groups.

b.Double-click Users.

c.Click Add.

d.Click Locations, select your computer node and click OK.

e.Type 'Network Service' into the 'Enter the object names' or click Advanced, then Find Now and select it from the Search Results.

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.

6.Start MySQL Service.