We are on Moodle 3.4.2+ and soon we will upgrade to 3.6.x running on redhat enterprise 7.5, 64-bit with php 7.1.8 and MySQL 5.7.24-community edition.
We have decided to tell users that we will delete their manual course backup file that have been there for more than 6 months off the system. This is to free our moodledata space and for housekeeping.
Can I write a script (any language) to look through the file table, select the manual ones and then delete them on the /moodledata folder (I know which column in the table to look for its path)? would that affect the integrity of the table in any way after I delete the associated row in the table and the file itself?