:: DEVELOPER ZONE
MySQL Reference Manual :: 13.5.2.7 RESTORE TABLE Syntax
Search the MySQL manual:
- 13.5.2 Table Maintenance Statements
- 13.5.2.1 ANALYZE TABLE Syntax
- 13.5.2.2 BACKUP TABLE Syntax
- 13.5.2.3 CHECK TABLE Syntax
- 13.5.2.4 CHECKSUM TABLE Syntax
- 13.5.2.5 OPTIMIZE TABLE Syntax
- 13.5.2.6 REPAIR TABLE Syntax
- 13.5.2.7 RESTORE TABLE Syntax
Additional languages
Additional formats
RESTORE TABLEtbl_name[,tbl_name] ... FROM '/path/to/backup/directory'
Restores the table or tables from a backup that was made with
BACKUP TABLE. Existing tables are not
overwritten; if you try to restore over an existing table, you get
an error. Just as BACKUP TABLE, RESTORE
TABLE currently works only for MyISAM
tables. The directory should be specified as a full pathname.
The backup for each table consists of its .frm
format file and .MYD data file. The restore
operation restores those files, 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.
The statement returns a table with the following columns:
| Column | Value |
Table
|
The table name |
Op
|
Always restore
|
Msg_type
|
One of status, error,
info, or warning
|
Msg_text
|
The message |
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.