TMyBackup(Error 1099)

cybsistemas · Post by **cybsistemas** » 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

AndreyZ · Post by **AndreyZ** » 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.

cybsistemas · Post by **cybsistemas** » Mon 14 Mar 2011 14:42

Thank

AndreyZ · Post by **AndreyZ** » Mon 14 Mar 2011 15:36

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