MySQL table with identical name multiple times in same database
Resolved the problem through Azure Helpdesk
The problem was that the parameter dir_cache_fine_grained_enabled switched on during an Azure update.
This needed to be switched off and the DB server restarted. After restart things went back to normal
The parameter is not available to the public.