ZlawMySQLBackup V2
This Component is a fork from ZlawMYSQBackup.pas buildt by LAW@sii.hu .
It was ported from Delphi to Lazarus. IMHO it should compile with Delphi too (untested).
Thanks to LAW the Component was quite compatible.

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

The demo is patterned on marvellous HeidiSQL's Database Export.
Thanks for the inspiration.

Features:
- generates complete db backup which can be restored either with ZSQLProcessor 
  (which seems to be a little buggy) or my own Restoore Routine
- 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 one single backup script file
- hexadecimal blob backup (can be activated, was removed for my porposes)
- unescape varchar and text fields
- configurable with options: create/drop database, drop objects, use lock around inserts, etc.

Activating {$define USE_TZCONNECTION} in ZlawMYSQBackup.pas makes TZlawMySQLBackup derive from TZConnection.
Otherwise it is derived from ZlawConnection, which enhances functionality by reading connection data 
from an ini-File and the decryption reading an encrypted ini-file.

For crypting, LAW used DCPcrypt2 lib originally. 
For Lazarus install DCPcrypt package by OnlinePackageManager. 
To use encryption, just derive ZlawMySQLBackup from ZConnection and activate
{$define USE_ENCRYPTION}.

For comparison purposes i added the original .zip file.

Todo:
- test it
- get information about which chars to escape or to remove/exchange
- add support for more field types (fieldtype support now in a single procedure for better enhancement) !!!!
- check data formats for decimal and date fields
- add suppport to split backup files at large database tables.
- add support to backup to another database on the fly
- check all database commands for compatibility with other ZEOS protocols
- make installable component


If you have questions or suggestions, mail to law@sii.hu for original component
or to charlytango@gmx.at for the fork