We managed to fix it, thank you Lisa for your help.
Im afraid not, I spoke to BigWetFish and they have no record of a backup. There is a usermeta table, and have created a user table, trying to work through it now
Thank you Lisa, I wasn’t aware that was possible! I found the database but after consulting with my hosting provider, it appears as though our database does not have a users table (it was magically removed, and nobody knows where it went/how it happened). I’m assuming this means I will need to create a new users table and populate that with the administrator account as shown in the guide you suggested?