How do I recreate MySQL tables that are corrupt or deleted? [solved]

The table oc_filecache in my NextCloud installation was corrupted so I decided to delete it and recreate it but I can’t find a way to do that.
Most apps I’ve used in the past have database creation SQL files that can be used but I can’t find any in the NextCloud installation directory?

I solved the problem by configuring a new nextcloud install using a nextcloudtempnew database, using mysqldump to dump it’s oc_filecache table to a file, importing that to my nextcloud database, truncating the new oc_filecache table that had references to this new temporary installation, swapped the config.php file for the new install with the old one, deleted the new data directory, deleted the new database and things are working just fine now.

1 Like