DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) RESTORE TABLE

Info Catalog (mysql.info.gz) REPAIR TABLE (mysql.info.gz) Table maintenance SQL
 
 13.5.2.7 `RESTORE TABLE' Syntax
 ...............................
 
      RESTORE TABLE TBL_NAME [, TBL_NAME] ... FROM '/PATH/TO/BACKUP/DIRECTORY'
 
 Restores the table or tables from a 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.  Just as `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, 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 will take.
 
 The statement returns a table 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.gz) REPAIR TABLE (mysql.info.gz) Table maintenance SQL
automatically generated byinfo2html