Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Exporting Triggers

HeidiUser.1's profile image HeidiUser.1 posted 2 years ago in Import/Export Permalink

Hi. When exporting stored procedures and triggers to another database, for stored procedures the DEFINER and SQL SECURITY characteristic is exported correctly, but for triggers DEFINER will be reset to the current user-id and the originally defined Property is overwritten. It would be great if for exported triggers also the DEFINER property would be left as given.

Please login to leave a reply, or register at first.