TmySQLTools

TmySQLTools component allows to run MySQL diagnostic and repair operations such as Repair, Check, Analyze, Optimize, Backup and Restore.

Please note that TmySQLTools component doesn't perform these operations itself: it just executes maintenance queries on server side. Please find additional details at http://dev.mysql.com/doc/refman/5.0/en/table-maintenance-sql.html

BACKUP TABLE and RESTORE TABLE queries are deprecated in current MySQL versions (http://dev.mysql.com/doc/refman/5.0/en/backup-table.html).

We strongly recommend to use TmySQLDump component to backup your data, and TmySQLBatchExecute component to restore SQL-dumps instead of using TmySQLTools component for Backup and Restore operations.