I will move a CiviCRM installation to another server and realized some strange database issues: it was not possible to save contacts with phone number anymore. The problem are the triggers in the database: both
civicrm_phone_before_insert call a function
civicrm_strip_non_numeric(). On export of the whole database these triggers and functions are exported with "definers" - database users which do not exist anymore in the new database.
So it seems that you cannot easily dump your CiviCRM database and import your dump to a fresh database. How should I process that?
And why are there these triggers in the database? Why is this not handled on the level of the app?