Ok, to reply to your original question is not possible to
recover your notes if there isn't a database copy... but I can't
understand why there isn't, I checked and Bear database is saved (
and the file change it's modification date ) a few seconds after a
note is edited.
I'll keep investigating for possible database saving issue.
We also plan to build an automatic backup solution inside Bear.
I am having a similar issue, though there is no database.sqlite file available in the folder specified. I restarted my computer and all my notes disappeared. I'd really appreciate any help with this issue.
Let's see if these steps will help you. Sometimes TM can be a pain to get past files, especially if they're in a hidden folder.
On your Finder sidebar, is one of your mounted devices the name of your Time Machine drive? It should have a icon similar to the TM icon in your menubar as part of the icon.
If so, double-click on it and you should see a folder named Backups.backupdb. Open this folder (it will take a while). Next you should see a folder with the name of your computer, such as "Jen's Mac". Open that folder (again, might take a while). Here you will see a lot of folders with names that reflect the date and time of a particular backup, such as 2018-03-12-221907. Open one of these folders that you think might have your Bear database. When that folder is opened, you'll see the name of your boot hard drive, such as Macintosh HD. Open that folder. then open the Users folder, then your user folder. Then go to the Finder menubar and select Go, then scroll down and select Go to Folder. A dropdown window will appear with the text Go to the folder: and an empty field. Paste the following in there (substituting the names of your TM volume, your Mac, the filename):
/Volumes/Time Machine WH/Backups.backupdb/Tod’s Mac mini/2018-03-01-000838/MacintoshHD/Users/tod/Library/Containers/net.shinyfrog.bear/Data/Documents/Application Data/
You should see this file there: database.sqlite If not, then you have to repeat the process with ever-earlier backups until you find it.
Open another Finder Window and follow the step above to go to your current Library, like this:
Then drag and drop your found sqlite file from the TM backup to your local Finder folder as described above.
Then launch Bear and I'm pretty sure you'll have your database back as of the last date it was saved on TM.
Be sure that you substitute your volume, folder and file names in place of the ones in my illustration above.
Also, there are utilities around that will enable you to show invisible folders and files, which would let you see the ~/Library folder on either your TM drive or your local drive.
Thanks for your help! This worked to restore my notes, however no backup was made for my most recent version so I still lost a lot of data. I'm a bit upset about the data - I do manual backups periodically to avoid this issue but rely on Bear to save my data as well.
I also was unable to follow your instructions via the finder window. I instead carried out copying this file into my current library through the terminal.
Thanks again for your help. If there are any ways to force Bear to create backups more often that would be really helpful to know.