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.
