79473

Creating an Option File

lf you need to specify startup options when you run the server, you can indicate them on the command

linę or place them in an option file. For options that are used every time the server starts, you may find

it most convenient to use an option file to specify your MySQL configuration. This is particularly true under the following circumstances:

•    The installation or data directory locations are different from the default locations (c: \ Program

Files\MySQL\MySQL Server 5.6 and C:\Program Files\MySQL\MySQL Server 5.6\data).

•    You need to tune the server settings, such as memory, cache, or InnoDB configuration information

When the MySQL server starts on Windows, it looks for option files in several locations, such as

the Wndows directory, C:\, and the MySQL installation directory (for the fuli list of locations, see

Section 4.2.3.3, “Using Option Files”). The Wndows directory typically is named something like c:

\Windows. You can determine its exact location from the value of the windir environment variable using the following command:

C: >echo %WINDIR%

MySQL looks for options in each location first in the my. ini file, and then in the my. cnf file. However,

to avoid confusion, it is best if you use only one file. If your PC uses a boot loader where c: is not the

boot drive, your only option is to use the my. ini file. Whichever option file you use, it must be a plain text file.