tbl_name] ... FROM '
This statement is deprecated and is removed in MySQL 5.5.
Existing tables are not overwritten; if you try to restore over
an existing table, an error occurs. Just as for
RESTORE TABLE currently works
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.
RESTORE TABLE returns a result
set with the following columns.
|The table name|
|An informational message|