ESET Online Help

Search
Select the category
Select the topic

MySQL Dedicated Partition

 

1.Stop MySQL Service.

2.Move or copy the Data folder onto the dedicated partition, for instance, D:\.

warning

For editing the my.ini file, ensure it is saved in ANSI, not in UTF-8 format. We recommend using Notepad++, 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 '# 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.