<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • 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
    Chapter 4:  Database Administration 181 4  Database Administration 4.1  Con guring MySQL 4.1.1  mysqld Command-line Options In most cases you should manage mysqld options through option les.  See  Section 4.1.2 [Option les], page 186. mysqld  and  mysqld.server  reads options from the  mysqld  and  server  groups.  mysqld_ safe  read options from the  mysqld,  server,  mysqld_safe  and  safe_mysqld  groups.  An embedded  MySQL  server  usually  reads  options  from  the  server,  embedded  and  xxxxx_ SERVER, where  xxxxx  is the name of the application. mysqld accepts the following command-line options: --ansi Use  ANSI  SQL  syntax  instead  of  MySQL  syntax.   See  Section  1.7.2  [ANSI mode], page 31. -b, --basedir=path Path to installation directory.  All paths are usually resolved relative to this. --big-tables Allow big result sets by saving all temporary sets on le.  It solves most 'ta- ble full' errors, but also slows down the queries where in-memory tables would suce.  Since Version 3.23.2, MySQL is able to solve it automatically by using memory for small temporary tables and switching to disk tables where neces- sary. --bind-address=IP IP address to bind to. --character-sets-dir=path Directory where character sets are.  See Section 4.6.1 [Character sets], page 267. --chroot=path Put mysqld daemon in chroot environment at startup.  Recommended security measure.  It somewhat limits LOAD DATA INFILE and SELECT ... INTO OUTFILE though. --core-file Write  a  core   le  if  mysqld  dies.   For  some  systems  you  must  also  specify  -- core-file-size to safe_mysqld.  See Section 4.7.2 [safe_mysqld], page 274. Note that on some systems, like Solaris, you will not get a core le if you are also using the --user option. -h, --datadir=path Path to the database root.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

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

    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

  • 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