Symbolic Linking to SQlite Database

Julian Quintana's Avatar

Julian Quintana

18 Jan, 2012 03:45 PM

I've attempted to create a symbolic link to the SQlite DB found in Application Support, with the hopes of moving the DB to my dropbox folder. Dropbox seems to be causing a permissions error that is inhibiting this. Has anyone successfully moved the DB and do you know if the developers are planning on implementing this feature in order to use the same DB across several computers.

  1. Support Staff 1 Posted by drewmccormack on 19 Jan, 2012 10:58 AM

    drewmccormack's Avatar

    Hi Julian,
    We have plans to add iCloud syncing in the coming months.
    If you do want to try the link, and you should definitely make sure you have a good backup if you do, then

    1) Move the folder ~/Library/Application/Mental Case/Library.mentalcase2lib to your Dropbox
    2) Link to the folder from the original location. In Terminal type this

    ln -s <path-to-folder-in-dropbox> ~/Library/Application/Mental Case/Library.mentalcase2lib

    The path in dropbox could be something like this


    And I repeat: please make a good backup, because Dropbox syncing is not really supported, and there is some risk of data corruption, especially if the app is run simultaneously on two devices.

    Hope that helps.
    Kind regards,

  2. 2 Posted by Doug Stetar on 14 Mar, 2012 01:54 AM

    Doug Stetar's Avatar

    I've been attempting to implement the dropbox support as you outlined. However, I keep getting a second Data.sqlite file begin created with a name something like:
    Data.(Laptop's conflicted copy 2012-3-13).sqlite. Any thoughts?

  3. Support Staff 3 Posted by drewmccormack on 14 Mar, 2012 07:11 AM

    drewmccormack's Avatar

    Hi Doug,
    It is a risky business, because you can end up with a corrupt database.
    You must not run the app on two machines at once. If dropbox sees that the same file changed on two different machines, it will consider the files in conflict, and it then makes a copy of the older one in case you want to use that one. That is the extra file you are seeing.
    We are working on iCloud syncing now. If you would like to be in on the beta testing let me know. Probably not too long until we start testing.
    Kind regards,

  4. 4 Posted by Doug Stetar on 14 Mar, 2012 10:21 PM

    Doug Stetar's Avatar


    I would very much like to be in on the beta testing. My situation is such that I really need to sync between two macs (not to mention an iPad & iPhone). I use all of these regularly in learning Mandarin.

    Doug Stetar, MFA
    Chair, Media Studies Department
    Director, Media Research Lab
    Vancouver Island University
    [email blocked]

  5. Support Staff 5 Posted by drewmccormack on 15 Mar, 2012 07:42 AM

    drewmccormack's Avatar

    We'll let you know if we have something. Things aren't going so good with iCloud testing, so don't know exactly when that will be.


Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac