Offshore Software Outsourcing Company, offshore IT outsourcing services, offshore software development Russia

About ALTOROS: ALTOROS Systems is headquartered in Tampa, Florida and maintains an office near Boston, Massachusetts and technology development center in Belarus and Russia. ALTOROS specializes on providing value-added e-commerce and web-based software development and offshore software outsourcing services to emerging enterprises helping them successfully plan and implement business initiatives.

BACKUP TABLE tbl_name[,tbl_name...] TO '/path/to/backup/directory'

Copies to the backup directory the minimum number of table files needed to restore the table. Currently only works for MyISAM tables. For MyISAM tables, copies .frm (definition) and .MYD (data) files. The index file can be rebuilt from those two.

Before using this command, please see Backup.

During the backup, read lock will be held for each table, one at time, as they are being backed up. If you want to backup several tables as a snapshot, you must first issue LOCK TABLES obtaining a read lock for each table in the group.

The command returns a table with the following columns:

Column	Value
Table	Table name
Op	Always "backup"
Msg_type	One of status, error, info or warning.
Msg_text	The message.

Note that BACKUP TABLE is only available in MySQL version 3.23.25 and later.