BackUpToFile(AnsiString FileName) for large data

[easyblue]

Hello

If I am correct, currently if I do a database backup using TMyDump, the generated SQL are stored in the SQL, which is of TStrings type, and save to files using following:

pMyDump->Backup();
pMyDump->SQL->SaveToFile(FileName);

If the database is quite big, such will fail due to memory shortage and also very low speed.

Comparing to the backup in MySQLAdministrator, which directly save to a file, I think of an extension of new method BackupToFile(FileName)/RestoreFromFile(FileName) in TMyDump. How about your opinion?

[Ikar]

We'll consider your suggestion. However, TMyDump doesn't serve for processing large volume data, you'd better use TMyBackup for it.

[Guest]

However, TMyBackUp only works on the server side, and does not support the table structure, wile TMyDump works on the client side, and can completely restore the whole database in case of critical problem on server.
So I really appreciate the huge data support of MyDump.
THX.

[Ikar]

Most likely, we'll add this functionality at the next version of MyDAC.