BackUpToFile(AnsiString FileName) for large data

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
easyblue
Posts: 64
Joined: Wed 02 Feb 2005 13:02
Location: Shanghai

BackUpToFile(AnsiString FileName) for large data

Post by easyblue » Wed 02 Feb 2005 13:17

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
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 03 Feb 2005 09:32

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

Guest

Post by Guest » Fri 04 Feb 2005 01:02

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
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 04 Feb 2005 08:59

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

Post Reply