<< 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

    234 MySQL Technical Reference for Version 4.0.3 -s or --silent Silent mode.  Write output only when errors occur.  You can use -s twice (-ss) to make myisamchk very silent. -v or --verbose Verbose mode.  Print more information.  This can be used with -d and -e.  Use -v multiple times (-vv, -vvv) for more verbosity! -V or --version Print the myisamchk version and exit. -w or, --wait Instead of giving an error if the table is locked, wait until the table is unlocked before continuing.  Note that if you are running mysqld on the table with -- skip-external-locking, the table can only be locked by another myisamchk command. 4.4.6.3  Check Options for myisamchk -c or --check Check  table  for  errors.   This  is  the  default  operation  if  you  are  not  giving myisamchk any options that override this. -e or --extend-check Check the table very thoroughly (which is quite slow if you have many indexes). This  option  should  only  be  used  in  extreme  cases.   Normally,  myisamchk  or myisamchk --medium-check should, in most cases, be able to nd out if there are any errors in the table. If you are using --extended-check and have much memory, you should increase the value of key_buffer_size a lot! -F or --fast Check only tables that haven't been closed properly. -C or --check-only-changed Check only tables that have changed since the last check. -f or --force Restart myisamchk with -r (repair) on the table, if myisamchk  nds any errors in the table. -i or --information Print informational statistics about the table that is checked. -m or --medium-check Faster than extended-check, but only nds 99.99% of all errors.  Should, how- ever, be good enough for most cases. -U or --update-state Store in the `.MYI' le when the table was checked and if the table crashed. This should be used to get full bene t of the --check-only-changed option,
     

    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
  • 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