<< 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
    288 MySQL Technical Reference for Version 4.0.3 mysqladmin Utility for performing administrative operations, such as creating or dropping databases,  reloading  the  grant  tables,   ushing  tables  to  disk,  and  reopening log les.  mysqladmin can also be used to retrieve version, process, and status information from the server.  See Section 4.8.3 [mysqladmin], page 295. mysqlbug The MySQL bug report script.  This script should always be used when ling a bug report to the MySQL list. mysqld The SQL daemon.  This should always be running. mysqldump Dumps a MySQL database into a le as SQL statements or as tab-separated text les.  Enhanced freeware originally by Igor Romanenko.  See Section 4.8.5 [mysqldump], page 299. mysqlimport Imports  text   les  into  their  respective  tables  using  LOAD DATA INFILE.    See Section 4.8.7 [mysqlimport], page 304. mysqlshow Displays information about databases, tables, columns, and indexes. mysql_install_db Creates the MySQL grant tables with default privileges.  This is usually exe- cuted only once, when rst installing MySQL on a system. replace A utility program that is used by msql2mysql, but that has more general ap- plicability as well.  replace changes strings in place in les or on the standard input.  Uses a nite state machine to match longer strings rst.  Can be used to swap strings.  For example, this command swaps a and b in the given les: shell> replace a b b a -- file1 file2 ... 4.8.2  mysql, The Command-line Tool mysql is a simple SQL shell (with GNU readline capabilities).  It supports interactive and non-interactive use.  When used interactively, query results are presented in an ASCII-table format.  When used non-interactively (for example, as a lter), the result is presented in tab-separated format.  (The output format can be changed using command-line options.) You can run scripts simply like this: shell> mysql database < script.sql > output.tab If you have problems due to insucient memory in the client, use the --quick option!  This forces  mysql  to use  mysql_use_result()  rather than  mysql_store_result()  to retrieve the result set. Using mysql is very easy.  Just start it as follows:  mysql database or mysql --user=user_ name --password=your_password database.  Type a SQL statement, end it with `;', `\g', or `\G' and press Enter. mysql supports the following options:
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    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