(mysql.info) restore-table

Info Catalog

(mysql.info) repair-table

(mysql.info) table-maintenance-sql

 
 13.5.2.7 `RESTORE TABLE' Syntax
 ...............................
 
      RESTORE TABLE TBL_NAME [, TBL_NAME] ... FROM '/PATH/TO/BACKUP/DIRECTORY'
 
 `RESTORE TABLE' restores the table or tables from a backup that was
 made with `BACKUP TABLE'. Existing tables are not overwritten; if you
 try to restore over an existing table, an error occurs. Just as for
 `BACKUP TABLE', `RESTORE TABLE' currently works only for `MyISAM'
 tables. The directory should be specified as a full pathname.
 
 The backup for each table consists of its `.frm' format file and `.MYD'
 data file. The restore operation restores those files, and then uses
 them to rebuild the `.MYI' index file. Restoring takes longer than
 backing up due to the need to rebuild the indexes. The more indexes the
 table has, the longer it takes.
 
 `RESTORE TABLE' returns a result set with the following columns:
 
 *Column*    *Value*
 `Table'     The table name
 `Op'        Always `restore'
 `Msg_type'  One of `status', `error', `info', or
             `warning'
 `Msg_text'  The message
 

Info Catalog

(mysql.info) repair-table

(mysql.info) table-maintenance-sql