BackUpToFile(AnsiString FileName) for large data

BackUpToFile(AnsiString FileName) for large data

Postby 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?
easyblue
 
Posts: 64
Joined: Wed 02 Feb 2005 13:02
Location: Shanghai

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

Postby 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.
Guest
 

Postby Ikar » Fri 04 Feb 2005 08:59

Most likely, we'll add this functionality at the next version of MyDAC.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components