<< 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 287 4.8  MySQL Client-Side Scripts and Utilities 4.8.1  Overview of the Client-Side Scripts and Utilities All MySQL clients that communicate with the server using the  mysqlclient  library use the following environment variables: Name Description MYSQL_UNIX_PORT The   default   socket;     used   for   connections   to localhost MYSQL_TCP_PORT The default TCP/IP port MYSQL_PWD The default password MYSQL_DEBUG Debug-trace options when debugging TMPDIR The   directory   where   temporary   tables/ les   are created Use of MYSQL_PWD is insecure.  See Section 4.2.8 [Connecting], page 202. The `mysql' client uses the le named in the MYSQL_HISTFILE environment variable to save the command-line history. The default value for the history le is `$HOME/.mysql_history', where $HOME is the value of the HOME environment variable.  See Appendix F [Environment variables], page 770. All MySQL programs take many di erent options.  However, every MySQL program pro- vides a --help option that you can use to get a full description of the program's di erent options.  For example, try mysql --help. You can override default options for all standard client programs with an option le.  Sec- tion 4.1.2 [Option les], page 186. The following list brie y describes the MySQL programs: myisamchk Utility  to  describe,  check,  optimise,  and  repair  MySQL  tables.     Because myisamchk has many functions, it is described in its own chapter. See Chapter 4 [MySQL Database Administration], page 181. make_binary_distribution Makes a binary release of a compiled MySQL. This could be sent by FTP to `/pub/mysql/Incoming'  on  support.mysql.com  for  the  convenience  of  other MySQL users. msql2mysql A  shell  script  that  converts  mSQL  programs  to  MySQL.  It  doesn't  handle  all cases, but it gives a good start when converting. mysqlaccess A script that checks the access privileges for a host, user, and database combi- nation.
     

    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