I have a bit of a situation on my hands. I had an old Windows 7 OS implode about two months back. It imploded so spectacularly that I was unable to boot back into the system despite several days of trying, and had to wipe it and start over. Fortunately, I keep nothing of value on the OS drive (everything is backed up, synchronized to the cloud, or on a separate partition or disk). The only exception to this was my Joplin installation - not synced to the cloud, not backed up or exported.
I do have the user documents and settings folder from that Win7 install, including AppData Roaming and AppData Local, but little else. Unfortunately, when browsing for Joplin files within, I do not see anything resembling an SQL database, at least not by file extension.
I attempted to install the current version of Joplin on my (now revived) system on Windows 10 and tried dropping in my AppData Roaming folder, but this had no effect. I then uninstalled that and attempted to install from an “installer” file that, for some reason, was sitting in my Roaming folder (an auto-downloaded update, I assume). When I attempted this, I got a version conflict error as follows:
I tried replacing the AppData - Local - Programs - Joplin folder with the one from my Win7 install, but the error persisted.
As this installer file is dated October 2018, but the other files in my install are from Feb 2018, my guess is that I need to track down an earlier installer that will match my version. So after that long introduction, I have two questions:
1.) How do I determine the version number I need from these few files I have remaining?
2.) Where and how did Joplin store its database files in February 2018? Please tell me they’re sitting right there in AppData just in a pre-SQL implementation or something. I just want a raw text dump of my old notes, there weren’t all that many and I am happy to reimport them into a new (backed up!) installation manually.
I don’t see an SQL database file in the Roaming files, just some Cache folders and an empty Local Storage and logs folder:
The Local folder looks like this:
Thank you for reading, if you can help me solve this puzzle I would be most grateful. This is literally the only relatively important thing in my digital life that I did not have a backup solution for. Lesson learned, but it would be nice to get those notes back.