I managed to delete the wrong database tonight, it was the database for the gallery.
So at the moment I have just done a new install and later on I will add all of the pictures back again.
The time is now 11:53pm and I’ve had enough, even the stupid restore function built in to the gallery doesn’t work…. 😥