Who is 'backup_Mk047aB'@'%' from the error 'The user specified as a definer ('backup_Mk047aB'@'%') does not exist'
OK - This is really heinous!!!
I've been trying all day - posted the query and after doing that read following set of instructions on how to do Alternate Moving the database using phpMyAdmin -&gt; see the link and look at the heading Post Import Activities.
It reads

Very Important: If you have custom data profiles set up in your civiCRM, they may be present but for some unknown reason not be active. Go to your Administer &gt;&gt; Customize &gt;&gt; Custom Data and select &quot;View and Edit Custom Fields&quot;. Select &quot;Edit Field&quot; for any one of the custom fields in the group and save it without making any changes. This will make civiCRM aware of the custom data fields and everything should be back on track.

I've got two set of custom fields, did what I'd been tolded = didn't work; did it again with the second set = and voila, everything works again.
There's two things on my mind:
1.) Can any of the more tenured members comment on what the problem is - it must be a bug, it can't be by design!?
2.) Who the heck is user:backup_Mk047aB???