I found this which enabled me to execute SQL from terminal
But then found this & connected successfully with a 30 day trial of Navicat
I searched my Collab wiki database & removed all UID entries for my corrupted wikis & then deleted the corrupted wikis themselves.
Everything is running perfectly now
Given that the database entries (UIDs) appear encrypted or something, how did you figure out which table contained the entries and identify which UIDs relate to which projects?
Is probably something simple but when it comes to databases...I'm a beginner!
I did manage to connect with Navicat so can browse/edit with that.