GNU Info

(mysql.info)RESTORE TABLE

---

Next: CHECK TABLE Prev: BACKUP TABLE Up: Disaster Prevention

---

Enter node , (file) or (file)node

`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. Restore will take
longer than BACKUP due to the need to rebuilt the index. The more keys
you have, the longer it is going to take. Just as `BACKUP TABLE',
currently only works of `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.