found out that some of my databases of some of my sites had a #mysql50# prefix. Not knowing what it was I suddenly also discovered that none of these sites were accessible (aarrchhhhhh)

This seems to be a known issue: MySQL introduces encoding for table names that have non-ASCII characters (see Section 8.2.3,