Files related to themes in templates_c dir can safely deleted -except index.html- and XOOPS will create updated ones. This is useful when something is not displayed correctly in user view.
These processes are implemented in module XoopsCare that I recommend you.
About database, sorry to hear you don´t have a copy. I use the module backpack to download db backups regularly.
Good luck Steve.