<< 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
    308 MySQL Technical Reference for Version 4.0.3 Error code   13:   Permission denied Error code   64:   Machine is not on the network Note that the error messages are mostly system dependent! 4.8.10  How to Run SQL Commands from a Text File The mysql client typically is used interactively, like this: shell> mysql database However, it's also possible to put your SQL commands in a le and tell mysql to read its input from that le.  To do so, create a text le `text_file' that contains the commands you wish to execute.  Then invoke mysql as shown here: shell> mysql database < text_file You can also start your text le with a USE db_name statement. In this case, it is unnecessary to specify the database name on the command line: shell> mysql < text_file If  you  are  already  running  mysql,  you  can  execute  a  SQL  script   le  using  the  source command: mysql> source filename; For more information about batch mode, Section 3.6 [Batch mode], page 175. 4.9  The MySQL Log Files MySQL  has  several  di erent  log   les  that  can  help  you   nd  out  what's  going  on  inside mysqld: Log le Description The error log Problems encountering starting, running or stopping mysqld. The isam log Logs all changes to the ISAM tables.  Used only for debugging the isam code. The query log Established connections and executed queries. The update log Deprecated:  Stores all statements that changes data The binary log Stores all statements that changes something.  Used also for replication The slow log Stores all queries that took more than long_query_time to execute or didn't use indexes. All logs can be found in the mysqld data directory.  You can force mysqld to reopen the log les (or in some cases switch to a new log) by executing FLUSH LOGS.  See Section 4.5.3 [FLUSH], page 248. 4.9.1  The Error Log mysqld writes all errors to the stderr, which the safe_mysqld script redirects to a le called 'hostname'.err. (On Windows, mysqld writes this directly to `\mysql\data\mysql.err'.)
     

    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