Top Previous Next

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.

See also: Properties, Methods, Events, TMySQLDump, TMySQLBatchExecute components