When exporting to sql, HeidiSQL exports the security definer as dbusername@%
.
This causes problems when importing into a different system with a different database username.
My workaround is to download the sql as a file, and hand modify the SQL definers to be CURRENT_USER() instead.
Would it be possible for heidisql to automatically convert dbusername@%
to CURRENT_USER when exporting? this would enable me to import directly into the second database on another server using the [SQL export feature]??