(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