MyDump restore error

[Willo]

Hi,

im trying to use mydump for backup / restore purposes, im able to create de sql script. But i can restore it without geting an "out of memory" error.

is there a solution for that?

im using mydac 3.55 in delphi 7

[AndreyZ]

Hello,

We have fixed several bugs with the TMyDump component since MyDAC 3.55. Please try using the latest MyDAC version 7.1.3 and check if the problem persists.

[Willo]

Im using MyDac ver. 7.1.4 and the error on that application is the same.

Any sugestions?

[AndreyZ]

Try using the TMyDump.BackupToFile method instead of the TMyDump.Backup method. TMyDump.BackupToFile dumps data directly to a file, when TMyDump.Backup dumps data to the TMyDump.SQL property (i.e. data is stored in the memory), which can cause the "Out of memory" error when working with huge amount of data.