Online Documentation for SQL Manager for MySQL
Backup Tables
Backup Tables Wizard allows you to make a copy of all the table files to a local backup directory.
Currently MySQL supports backup only for tables of MyISAM storage engine. The service copies *.frm (definition) and *.myd (data) files. The index file can be rebuilt from those two. The copied table is locked with a read lock during the backup process.
Note: This tool is not accessible for MySQL 5.5 and higher.
Note: You cannot backup tables on a remote server; backup works only for local databases. To backup tables from a remote server, you can use Extract Database, and then restore them using SQL Script Editor.
To run the wizard, select the Services | Backup Tables... main menu item.
Availability: |
|
Full version (for Windows) |
Yes |
Lite version (for Windows) |
No |
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
See also: |