Does Time Machine backup iCloud Drive?

Hi Léonie and thank you for a very clear and helpful reply!

But...Ninox defies logic...

First, I cannot access the Ninox files via iCloud Drive as the files are invisible (forced by Ninox).

I can however use Option Go to get to the Library which offers

The path is Users > Name > Library > Containers > de.ninoxdb.nonox-mac.Ninox > Document > data >

However there is only one database showing (Publishing), not the one I want. What I now realise is (it seems) Ninox does not store DBs designated as Cloud in the local iCloud, but only on Apple. Here's a shot of my Ninox databases screen (messy with test dummies):

Most DBs are correctly designated as Cloud (so they can be accessed from two machines) but Publishing has been left as local and it is the only one visible in the local copy of iCloud.

So it seems Ninox bypasses local iCloud. Why is hard to imagine, but it does seem to mean I have to access the backups direct from the TimeMachine files.

Which gets me back to Ninox's cryptic instruction to access the files via Terminal.

Well, cryptic to me: I can follow instructions in Terminal but I can't solve problems like this one.

Any ideas?

Thanks.

I'm trying to recover a Ninox (desktop version) database. The path to the data base files on the laptop is

~/Library/Containers/de.ninoxdb.ninox-mac.Ninox/Data/Documents/data

and Library appears in my TimeMachine backup, so I think it should be there.

However, the files are hidden, so while I can see them in the Desktop (using Option Go) I can't see them in Time Machine.

Ninox say the path within iCloud is

d ~/Library/Mobile\Documents/BJE6SD455T~de~ninoxdb~ninox-ios/data

but that this can only be accessed via Terminal not via Finder. This exceeds my ability.

Unfortunately Ninox help is no real help, they just keep repeating the path above and telling me they "believe" the files can be copied and pasted to restore them. Ultimately they suggest I get lost and ask Apple.

The storing of databases in hidden iCloud files is forced by Ninox, who say in turn that Apple forces them to use this approach, to enable access to the same data from both my desktop and laptop. As I have other files sitting in iCloud (and DropBox) that I can access from both machines, I'm not really convinced by this.

Certainly I don't have a solution.

Hi Léonie and thank you for your continued patience guiding me through my ignorance.

The file I am trying to recover is in a TimeMachine backup on an external drive so I guessed the Terminal instruct as (not sure about the first bit):

open /TimeMachine3TB/Backups.backupdb/Michaels iMac (2)/2020-03-09-215314/MiMac/System/Library/Mobile\ Documents/BJE6SD455T~de~ninoxdb~ninox-ios/data

but this returns:

-bash: syntax error near unexpected token `('

I'm wondering if I should rename the iMac in the Time Machine backup to remove the ( and )?

Michael