|
Home
/ Technical Support / MySQL
Key Offerings:
B2B and B2C E-Business
Solutions
Offshore
Software Development Outsourcing
Strategic Consulting
Offshore Software Outsourcing
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.
Contact Us for more
information.
BACKUP TABLE Syntax
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.
|