Easy way to Purge / delete old recordings?

Is there an easy way to purge the DB and recorded files?

Back in ver 2.0 I use to be able to set the Disk space limit to like 1 or 2% and it would based on that purge out all the files / recordings until it reached that disk use %. I tried that in the 3.0, and did not appear to work.
I have 1TB drive set for the system. It had been using the global constant record.
I tried that trick and it did not seem to work. I install Webmin on it and used the file manager to purge out the recordings, Have my cameras set correctly for ONVIF trigger recording since all the cameras support that.
The system is now recording things. and have like 8 days of storage instead of like 2 hours.

Hello, I did manage to get the file / recordings to delete by decreasing the % disk space to like 1%. It takes a bit of time to delete out and open up the space. I assume when I shrink that disk use % to a very small value, it besides deleting the recordings it I assume is also removing the records from the DB? If anyone can explain what the DVR does when you say go from 80% disk use to say 2% disk use as to what all is being deleted and cleaned up due to the decrease in drive space allowed for recordings.

I don’t believe we remove the events from the database once files are deleted.

You could run truncate the EventsCam table and the system should realize there are events on the file system that do not exist in the database and remove them.

I can give you a command to truncate the EventsCam if you need.

That would be great, My SQL skills / commands are not good. I will appreciate that script / command.
I am sure I am a one off, but just encase others would want to purge files and keep the DB events cleaned up it might be useful for them as well.


Hello, Sorry it has been so busy, changing jobs and all. Where can I go get the script to run truncate the EventsCam table? Or am I miss reading it and that is the command to execute.

So if I ssh into the server as me, then sudo over to bluecherry user account and then just run the command “run truncate the EventsCam table” at the command line that will do the job?

Sorry for not fully understanding the process. How is the DVR user manual coming along. That might be a good place to make a footnote section on some command / processes that for the most part 99% of everyone would likely never use, but be nice to have documented for the rare few of us who do liek to do manual DB / recording cleanup and purge things out.