Restore table syntax-MySQL database

Restore tableTbl_name[,Tbl_name]... From'/Path/to/backup/directory'
 

Used to recover fromBackup tableThe table to be backed up. The original table will not be overwritten; if you try to overwrite the original table, an error will occur. AndBackup tableSame,Restore tableCurrently, onlyMyISAMTable. The directory should be specified as a complete path name.

The backup of each table includes. FRMFormat File and. MYDData file. The recovery operation will restore these files and then use these files to recreate them.. MyiIndex file. The Restoration Operation takes longer than the backup operation because the index needs to be rebuilt. The more indexes a table contains, the longer it takes.

This statement returns a table containing the following columns:

column	value
table	table name
op	restore
msg_type	Status, error, information, or warning
msg_text	message