I’ve fixed the gallery up now, had to redo the database manually.
There is a back up option built in to Gallery2 which I do use after doing large updates. But the restore option does not work. Sort of pointless having a backup which is not a stand sql dump if your own utility wont restore it.
So I’ll be looking at doing some standard backups in the future.
I’ve added all of the users back in with the same passwords and access that were there before.