Devart Forums

Posted: **Sat 12 Mar 2011 20:43**

MySQL Version 5.5.9
MyDAC Version 6.00.0.4

MyBackup1.Path := 'C:\Temp\;
MyBackup1.Mode := bmBinary;
MyBackup1.Backup;

Table 'xxxx' was locked with a READ lock and can't be

MyBackup1.Mode := bmText;
MyBackup1.Backup;

It works correctly

Posted: **Mon 14 Mar 2011 14:17**

Hello,

In the bmBinary mode MyDAC uses the "BACKUP TABLE" statement that works only for MyISAM tables. This statement is deprecated and was removed in MySQL 5.5. You should use the bmText mode instead of the bmBinary mode to backup tables with MySQL 5.5.

Posted: **Mon 14 Mar 2011 14:42**

Thank

Posted: **Mon 14 Mar 2011 15:36**

Feel free to contact us if you have any further questions about MyDAC.

Devart Forums

TMyBackup(Error 1099)

TMyBackup(Error 1099)