Document the steps required to export the CiviCRM database and exclude triggers to avoid the "invalid definer permission" error issue
Document the steps required to export the CiviCRM database and exclude triggers to avoid the "invalid definer permission" error issue. https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/
mysql-dump --skip-triggers
This change is also dependent on dev/core#2124 (closed)
The "Misc" section should also be moved to something like "Common Administration Tasks". Also related to #74
Background info
skip-triggers was around 9 years ago - https://serverfault.com/questions/327079/exporting-mysql-without-trigger-data
"If the DEFINER clause is omitted, the default definer is the user who executes the CREATE TRIGGER statement. This is the same as specifying DEFINER = CURRENT_USER explicitly."
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
Agileware Ref: CIVICRM-1584