
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 are not overwritten; if you try to restore over
an existing table, you 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 takes.
