MySQL Manual
4 Database Administration
4.4.3 RESTORE TABLE Syntax
RESTORE TABLE tbl_name[,tbl_name...] FROM '/path/to/backup/directory'
Restores the table(s) from the 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. Restoring
will take longer than backing up due to the need to rebuild the index. The
more keys you have, the longer it will take. Just as BACKUP TABLE,
RESTORE TABLE currently works only for MyISAM tables.
The command returns a table with the following columns:
| Column | Value |
| Table | Table name |
| Op | Always restore
|
| Msg_type | One of status, error, info, or warning
|
| Msg_text | The message |
