So I got this sorted, it was indeed the / prefix causing the issue. The reason I couldn't rename the tables was that for some reason I had 2 complete sets, one with the / prefix and one without.
I deleted the tables without the /, I was then able to rename the / tables to no prefix. Edited the conf_global and hey presto - a working upgrade!
Thank you everyone for the help 🙂