(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