
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.
