Dyntex.net Support Centre: MySQL Reference Manual p.68

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

68 MySQL Technical Reference for Version 4.0.3 You will need to use an option le to specify your MySQL conguration under the following circumstances: The installation or data directories are dierent from the default locations (`c:\mysql' and `c:\mysql\data'). You want to use one of these servers: mysqld.exe mysqld-max.exe mysqld-max-nt.exe You need to tune the server settings. Normally you can use the WinMySQLAdmin tool to edit the option le my.ini. In this case you don't have to worry about the following section. There are two option les with the same function: `my.cnf' and `my.ini'. However, to avoid confusion, it's best if you use only of one them. Both les are plain text. The `my.cnf' le, if used, should be created in the root directory of the C drive. The `my.ini' le, if used, should be created in the Windows system directory. (This directory is typically something like `C:\WINDOWS' or `C:\WINNT'. You can determine its exact location from the value of the windir environment variable.) MySQL looks rst for the my.ini le, then for the `my.cnf' le. 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' le. Also note that if you use the WinMySQLAdmin tool, it uses only the `my.ini' le. The `\mysql\bin' directory contains a help le with instructions for using this tool. Using notepad.exe, create the option le and edit the [mysqld] section to specify values for the basedir and datadir parameters: [mysqld] # set basedir to installation path, e.g., c:/mysql basedir=the_install_path # set datadir to location of data directory, # e.g., c:/mysql/data or d:/mydata/data datadir=the_data_path Note that Windows pathnames should be specied in option les using forward slashes rather than backslashes. If you do use backslashes, you must double them. If you would like to use a data directory dierent from the default of `c:\mysql\data', you must copy the entire contents of the `c:\mysql\data' directory to the new location. If you want to use the InnoDB transactional tables, you need to manually create two new directories to hold the InnoDB data and log lese.g., `c:\ibdata' and `c:\iblogs'. You will also need to add some extra lines to the option le. See Section 7.5.2 [InnoDB start], page 507. If you don't want to use InnoDB tables, add the skip-innodb option to the option le. Now you are ready to test starting the server.

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide