(mysql.info.gz) Windows create option file
Info Catalog
(mysql.info.gz) Windows extract archive
(mysql.info.gz) Windows installation
(mysql.info.gz) Windows select server
2.3.8 Creating an Option File
-----------------------------
If you need to specify startup options when you run the server, you can
indicate them on the command line or place them in an option file. For
options that will be used every time the server starts, you will find it
most convenient to use an option file to specify your MySQL
configuration. This is true particularly under the following
circumstances:
* The installation or data directory locations are different from
the default locations (`C:\mysql' and `C:\mysql\data').
* You need to tune the server settings. For example, to use the
`InnoDB' transactional tables in MySQL 3.23, you must manually add
some extra lines to the option file, as described in
`InnoDB' configuration InnoDB configuration. (As of MySQL 4.0,
`InnoDB' creates its data files and log files in the data
directory by default. This means you need not configure `InnoDB'
explicitly. You may still do so if you wish, and an option file
will be useful in this case, too.)
When the MySQL server starts on Windows, it looks for options in two
files: the `my.ini' file in the Windows directory, and the `C:\my.cnf'
file. The Windows directory typically is named something like
`C:\WINDOWS' or `C:\WinNT'. 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 first in the `my.ini' file, then in the
`my.cnf' file. However, to avoid confusion, it's best if you use only
one file. If your PC uses a boot loader where the `C:' drive isn't 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.
You can also make use of the example option files included with your
MySQL distribution. Look in your install directory for files such as
my-small.cnf, my-medium.cnf, my-large.cnf, etc., which you can rename
and copy to the appropriate location for use as a base configuration
file.
An option file can be created and modified with any text editor, such
as the `Notepad' program. For example, if MySQL is installed at
`E:\mysql' and the data directory is located at `E:\mydata\data', you
can create the option file and set up a `[mysqld]' section to specify
values for the `basedir' and `datadir' parameters:
[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=E:/mydata/data
Note that Windows pathnames are specified in option files using forward
slashes rather than backslashes. If you do use backslashes, you must
double them:
[mysqld]
# set basedir to your installation path
basedir=E:\\mysql
# set datadir to the location of your data directory
datadir=E:\\mydata\\data
On Windows, the MySQL installer places the data directory directly
under the directory where you install MySQL. If you would like to use
a data directory in a different location, you should copy the entire
contents of the `data' directory to the new location. For example, by
default, the installer places MySQL in `C:\mysql' and the data
directory in `C:\mysql\data'. If you want to use a data directory of
`E:\mydata', you must do two things:
* Move the data directory from `C:\mysql\data' to `E:\mydata'.
* Use a `--datadir' option to specify the new data directory location
each time you start the server.
Info Catalog
(mysql.info.gz) Windows extract archive
(mysql.info.gz) Windows installation
(mysql.info.gz) Windows select server
automatically generated byinfo2html