DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) BACKUP TABLE

Info Catalog (mysql.info.gz) ANALYZE TABLE (mysql.info.gz) Table maintenance SQL (mysql.info.gz) CHECK TABLE
 
 13.5.2.2 `BACKUP TABLE' Syntax
 ..............................
 
      BACKUP TABLE TBL_NAME [, TBL_NAME] ... TO '/PATH/TO/BACKUP/DIRECTORY'
 
 * This statement is deprecated. We are working on a better
 replacement for it that will provide online backup capabilities.  In
 the meantime, the `mysqlhotcopy' script can be used instead.
 
 `BACKUP TABLE' copies to the backup directory the minimum number of
 table files needed to restore the table, after flushing any buffered
 changes to disk. The statement works only for `MyISAM' tables.  It
 copies the `.frm' definition  and `.MYD' data files. The `.MYI' index
 file can be rebuilt from those two files.  The directory should be
 specified as a full pathname.
 
 Before using this statement, please see  Backup.
 
 During the backup, a read lock is held for each table, one at time, as
 they are being backed up. If you want to back up several tables as a
 snapshot (preventing any of them from being changed during the backup
 operation), you must first issue a `LOCK TABLES' statement to obtain a
 read lock for every table in the group.
 
 The statement returns a table with the following columns:
 
 *Column*    *Value*
 `Table'     The table name
 `Op'        Always `backup'
 `Msg_type'  One of `status', `error', `info', or
             `warning'
 `Msg_text'  The message
 
 `BACKUP TABLE' is available in MySQL 3.23.25 and later.
 
Info Catalog (mysql.info.gz) ANALYZE TABLE (mysql.info.gz) Table maintenance SQL (mysql.info.gz) CHECK TABLE
automatically generated byinfo2html