Sets operation with which tables from. TableList property you want to be processed.

Syntax:

MySQLOperation : TMySQLOperation;
Type
TMySQLOperation = (oOptimize, oCheck,oAnalyze,oRepair,oBackup,oRestore);

Description:

Default value is oCheck.

Possible parameters values:

oRepair

Repairs a possible corrupted table;

oCheck

Checks the table(s) for errors;

oRestore

Restores the table(s) from the backup that was made with BACKUP;

oOptimize

OPTIMIZE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows;

oAnalize

Analyse and store the key distribution for the table;

oBackup

Backups the table(s).