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:
