Definer ('something'@'%') does not exist error

In case you are curious if you have this issue, you can see the 'DEFINER' column in the TRIGGERS if you have ddev phpmyadmin:

Apparently if we trigger a resave of the DER base field it fixes the issue according to 💬 DER fields lead to problems when syncing database between different environments Fixed . So I think we need to somehow trigger the BaseFieldDefinition resave https://git.drupalcode.org/project/scheduled_transitions/-/blob/2.8.x/sr...

I'll try to see what before and after looks like for that. New installs does not seem to be an issue but we have some old sites that still run into this and my colleague runs a little script to sort each time:

Max
sed -i '' 's/DEFINER=[^*]*\*/\*/g' db_dump.sql

Linux
sed -i 's/DEFINER=[^*]*\*/\*/g' db_dump.sql

Nope, still a problem with latest DER; DEFINER still exists in the export