<< 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 229 4.4.3  RESTORE TABLE Syntax RESTORE TABLE tbl_name[,tbl_name...] FROM '/path/to/backup/directory' Restores the table(s) from the backup that was made with BACKUP TABLE.  Existing tables will not be overwritten - if you try to restore over an existing table, you will get an error. Restore will take longer than BACKUP due to the need to rebuilt the index.   The more keys you have, the longer it is going to take.  Just as BACKUP TABLE, currently only works of MyISAM tables. The command returns a table with the following columns: Column Value Table Table name Op Always \restore" Msg type One  of  status,  error,  info  or warning. Msg text The message. 4.4.4  CHECK TABLE Syntax CHECK TABLE tbl_name[,tbl_name...] [option [option...]] option = QUICK | FAST | MEDIUM | EXTENDED | CHANGED CHECK TABLE  only  works  on  MyISAM  and  InnoDB  tables.   On  MyISAM  tables  it's  the  same thing as running myisamchk -m table_name on the table. If you don't specify any option MEDIUM is used. Checks the table(s) for errors.  For MyISAM tables the key statistics is updated.  The com- mand returns a table with the following columns: Column Value Table Table name. Op Always \check". Msg type One  of  status,  error,  info,  or warning. Msg text The message. Note that you can get many rows of information for each checked table.  The last row will be of Msg_type status and should normally be OK.  If you don't get OK, or Not checked you should normally run a repair of the table.  See Section 4.4.6 [Table maintenance], page 231. Not checked means that the table the given TYPE told MySQL that there wasn't any need to check the table. The di erent check types stand for the following: Type Meaning QUICK Don't scan the rows to check for wrong links. FAST Only check tables which haven't been closed properly. CHANGED Only check tables which have been changed since last check or haven't been closed properly.
     

    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