I have two related questions regarding the deletion of uploaded files in ver 2.9.
I, as an administrator, have uploaded various video files and then have uploaded newer files that replace the original files. The newer files do not have the same name. So, these older, large files are uselessly taking up space on disk and I would like to delete them.
Question 1) When you delete a file from a resource record (for example, a file or a videofile resource), I presume that you are just removing the link from the physical file in moodledata to the resource record, but the physical file is itself not deleted. If this is so, then how to delete the physical file from disk?
Question 2) Following up on that question, if the same physical file is linked to two or more different resources, is there a way to identify within Moodle to which resources it is linked? And if not, can someone provide the sql required to find out within the database?