Many thanks Lorraine !!; updating the wp_site and wp_blog to have /wordpress/ in the table path column fixed the 404 issue with wp-admin.
However I now see another issue. As mentioned previously this was a single site that was upgraded to a multisite. I see my old site in the new manage sites menu and I can edit the old blog post. However I cannot view them. The view url in the admin panel refers to
https://www.mysite.com/blog/2013/05/20/mypost
Which does not work even if I remove the blog part. I also see in the wp_blog table that my post are still referring to https://www.mysite.com/?p=20 etc.
I’ve seen a few reference to using a plugins to remove the blog part but not sure how to update my wp_blogs table to see my previous post again ?
Thanks