Inquiry on safely identifying and cleaning up orphaned .crypted files in Joplin resources directory

Support
1

What issue do you have?

After using Joplin for years, I've accumulated a large number of files in the resources directory.
While the image files can be efficiently managed and cleaned using the excellent Joplin Batch plugin, I’m unsure how to handle the .crypted files. Among them:
Some share the same base filenames as existing images (excluding extensions).
Many others appear to have no corresponding images or notes.
To investigate, I ran the following AI-suggested SQL query on the resourcestable:
SQL Query provided by AI:

sqlite3 .../joplin-desktop/database.sqlite "
SELECT
    r.id AS 'ID',
    r.title AS 'name'
FROM
    resources r
WHERE
    r.id = 'xxxxxxxx';
"

The query results indicate that over xxx resource IDs​ (corresponding to the base filenames of the .crypted files, without extensions) have no matching records​ in the resources table.
Questions:​
How can I safely identify which of these .crypted files are truly orphaned and can be deleted?
What is the recommended process to clean them up without impacting existing notes or causing data loss?

Thank you for your guidance—and sincere appreciation to the Joplin open-source community for this invaluable tool.

2

You can just delete ALL .crypted files, as they are only needed during encryption / decryption. But fully close Joplin before doing so.

1 Like
3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.