5

I have an old Ubuntu machine that no longer works, but I can still access its drive through a live USB. None of the notes were ever exported; though, I was expecting to recover them by some other means. How do I do this? I see the Joplin app folder/files and that it was installed on the machine via snap.

7

Those are stored in an SQLite database. Default location (normal and snap):

~/.config/joplin-desktop/database.sqlite
~/snap/joplin-desktop/current/.config/joplin-desktop

Find the one you are after on your system and then from command line you can do ...

sqlite3 ~/.config/joplin-desktop/database.sqlite
sqlite3 ~/snap/joplin-desktop/current/.config/joplin-desktop

and then use the SQL language to view and dump data from it. .help will show available options.

5
  • Note that location of the snap application will be different, somewhere under ~/snap
    – vanadium
    Sep 24 at 11:16
  • @vanadium yeah found it online just now.
    – Rinzwind
    Sep 24 at 11:40
  • 2
    An easier and more powerful way to access data is with sqlitebrowser. Sep 24 at 12:54
  • yep, that's one of my most upvoted answers
    – qwr
    Sep 24 at 19:18
  • Or copy the .sqlite file to a current system which can access the information. Unlike some more traditional databases, the .sqlite is all you need to read/transfer an SQLite database.
    – Mast
    Sep 25 at 3:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.