TMyDump does not backup triggers

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Hans
Posts: 52
Joined: Wed 24 Aug 2005 20:05

TMyDump does not backup triggers

Post by Hans » Thu 11 May 2006 13:46

Hi,

Does anyone know how to backup triggers and stored procedures. Triggers are not included in the backup and stored procedures use something like a delimiter $$ which causes an error in my MySQL 5.0 database.

best regards,
Hans

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 12 May 2006 08:37

> Does anyone know how to backup triggers...
Now TMyDump doesn't support working with triggers, but we are considering support of this feature in the next MyDAC version.

> stored procedures use something like a delimiter $$
Try downloading last version of MyDAC (4.30.0.12). If problem persists then send us complete small sample to demonstrate it, including script to create server objects.

Post Reply