[DUG] DAC Dump Component - MySQL backup

Graham Marsden graham at wk.planet.gen.nz
Mon May 2 15:37:44 NZST 2011


Hi Bob

I could not find an example of the use of the DAC Dump component either.
It looks fairly straightforward though: Define a connection, double click the component (design time) and enter the 
table names (if nothing entered then all tables are dumped), then use the  <componentname> .Backup method to 
set it off. Setting of the tables to be backed up programatically could be done as well.

The DAC Backup Component is very similar in setup and execution with the added benefit of the backup being all 
server side with no network traffic overhead and therefore a faster execution.

There is an addional option for the backup of a database ... use the scheduled backup available in the MySQL 
Administrator which is downloadable from the MySQL website (you probably have it already.)

Hope this helps

Graham Marsden


More information about the Delphi mailing list