Oc_storages does not exist - how to recreate

ℹ️ Support
1

Nextcloud version: 20.0.1
Operating system and version: Ubuntu 20.04
Apache 2.4
PHP version 7.4

The issue you are facing:
when trying to do an update to 20.0.2 I crashed everything yesterday, on restoring the backup file with

mysql -h [server] -u [username] -p[password] [db_name] < nextcloud-sqlbkp.bak

I now end up with an error:

Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing ‘SELECT id, numeric_id, available, last_checked FROM oc_storages WHERE id = ?’ with params [“local::/media/owncloud-data/”]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nextcloud.oc_storages’ doesn’t exist
Update failed

Is there a way to regenerate this table ? I do not have a lot of “storages” , actually only exactly 1 , so even if I could just get the table structure it might help me

thank you

2

By more and more googling I found a structure for the oc_storages

but now I need a structure for oc_vcategory, is anybody able to advise what the minimum table I need to create for that is

thank you

3

I ended up trying to install a VM and copy each table structure out of there. In the end my SQL dump was so corrupted that had to totally reinstall the server from a blank database…