MySQL export with definers

[expired user #1502]'s profile image [expired user #1502] posted 8 years ago in General Permalink

When I exporting MySQL database into SQL file (RMB over database | Export database as SQL) HeidiSQL dumps DEFINER for VIEWS/STORAGE PROCEDURES, but not for TRIGGERS.

It would be nice if HeidiSQL be consistent and dump triggers' definers as well. Also, it will be nice to have a new add option (under "Options" button) that could be used for include/exclude definers from dump (I do not need this, but looks like some people would like to exclude definers from dump).

Thanks.

P.S. HeidiSQL 9.3.0.5083

BubikolRamios's profile image BubikolRamios posted 8 years ago Permalink

To be able to exclude: select Tree style options/group objects by type That then reflects in 'Export database as SQL' any you can exclude If triggers are not in export, doh checked, then this is a bug.

[expired user #1502]'s profile image [expired user #1502] posted 8 years ago Permalink

I do not want to exclude objects by type(s). I'd like to see triggers' definers exported (views/storage procedures definers are exporting now).

Optionally, I suggest to add a new option that can be used to exclude objects' definers (not objects) from export (some people might find this option useful).

Tsioh Ni's profile image Tsioh Ni posted 8 years ago Permalink

I agree with @Misha v.3. An option to exclude/include definers would be a great feature.

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