ZlawMySQLBackup

Component for Delphi (tested on D7) to backup MySQL databases (5.0.3 and above)
based on ZeosLib.
This is an experimental version, use it at your own risk.


Features:
- generates complete db backup which can be restored with ZSQLProcessor
- backup tables with keys and constraints, views, stored procedures, 
stored functions and triggers
- uses SHOW statements to get DDL
- uses information_schema database for triggers
- data is saved to bulk inserts in the backup script
- hexadecimal blob backup (tested only with little blobs)
- unescape varchar and text fields
- added options: create/drop database, drop objects, use lock around inserts, etc.


ZlawMySQLBackup derived from ZlawConnection, which is derived for ZConnection.
ZlawConnection read the connection properties from crypted ini file (sample ini
in the source directory). For crypting, I used DCPcrypt2 lib. If you don't want 
to use it, just derive ZlawMySQLBackup from ZConnection.


Todo:
- test it
- get information about which chars to escape
- add support for more field types
- check data formats for decimal and date fields


If you have questions or suggestions, mail to law@sii.hu