Broken multisite after failed upgrade and restore

Hi,
after years of delay, I decided to upgrade my multisite version of WordPress to the latest one. I downloaded the Italian version of of WordPress here

https://it.wordpress.org/download/

created the backup of my website and database according to the instructions (https://wordpress.org/documentation/article/updating-wordpress/) and started the upgrade.
I must confess I skipped the deactivation of the plugins, but a couple of weeks ago I successfully upgraded a very old WordPress site after 8 years to the latest one even if I forgot to disable the plugins first also on that occasion.

At any rate, after deleting and copying the files correctly, I unsuccessfully tried to go to the admin page of my site (500 error) – I used the wrong adress though, mywebsite/wp-admin instead of mywebsite/wp-admin/network, but I realized this afterwards – so I panicked and tried to restore the old site, also unsuccessfully.

I tried to re-update WordPress again and got an error about connection to Database. I added this line

define('WP_ALLOW_REPAIR', true);

to my wp-config.php and when I access the page mywebsite/wp-admin/maint/repair.php I saw that these 2 columns could not be found:

wp_options: Table ‘Sql598794_1.wp_options’ doesn’t exist
wp_blogmeta: Table ‘Sql598794_1.wp_blogmeta’ doesn’t exist

I am pretty sure I saw the wp_options column earlier in myPhpAdmin because I was looking for the active-plugins, but now I cannot after my Database restoration of the backup failed with the error

1146 – Table ‘Sql598794_1.wp_5_posts’ doesn’t exist

I apologize for the mess, but could you please advise what could I try to do to restore the multisite functionality? Thanks in advance.

• This topic was modified 2 minutes ago by James Huff. Reason: moved to Networking WordPress since this is a multisite issue

The page I need help with: [log in to see the link]