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. The directory should be specified as a full path
name.

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. Restored tables are not
replicated from master to slave.

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.

URL: http://dev.mysql.com/doc/refman/5.1/en/restore-table.html

