Data Recorder: How can I delete old data?

[LunatiX]

How can I delete the data within the sqlite database, which has stored the data of the Data Recorder? 

Background info: when I do a backup/restore on a new control, I don't wan't to have to old sqlite-data on the new control.

[webiq-sk]

That depends on how you do the "restore". The simplest way to be to have an empty recorder database for the corresponding recorder(s) in the ZIP file you deploy to the runtime system as this will replace the existing data with the one from the ZIP file which would then be empty.

[LunatiX]

Unfortunately first I opened the existing project with the WebIQ Designer and changed the project. Then I published the project and did the backup. Then I realized, that the project is now more than 200MB big and the download takes longer. In that case it will be good to delete the sqlite db.

[webiq-sk · Accepted solution]

Yes, deleting the database would work on any system except ctrlX currently because you do not have direct access to the files of the HMI because it's all inside the app. As such you could of course extract the backup, open the SQLite file using e.g. SQLite Studio and deleting all of the associated data rows and then zip the project again and upload it.

Please note that you have to ensure you actually delete the correct rows so this is at your own risk. Omitting the database from the ZIP file will simply not overwrite the existing data when uploading the HMI again.