Home / server / Questions / 67785
Accepted
shaiss
Asked: 2009-09-23 10:34:54 +0800 CST

Read an InstantDB .db file

  • 772

I have our database files that we've recovered from our server that was running ShopSite 7. ShopSite themselves are no help. Anyhow, I've managed to recover our orders and customers tables.

However, they are a .db file. Its not paradox according to

pxinfo -f path_to_db

The begining of the file starts like this (copied from vim)

IDB 2.1^@>^@^@^@^@^H^@^@^^G^@^@àç^Z^@ÐD6^@@^@^@^@^C^@^@^@ø<^@^@^H^A^@^@ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ^@^@^@^@^B^@^@^@^O^@^@^@Date_i18n_N65

Searching on IDB 2.1 lead me to InstantDB, which has been MIA since 2001 apparently. I've tired DbVizualizer but had no luck with that.

Anyone have any ideas how to read this file? See the pastie link for the header row and first record. It looks like garbage, but there is a pattern there.

database

1 Answers

  1. Best Answer

    Download this file:

    http://jmatrix.net/actions/attachment.do?id=7F000001-81B1FB-12063F02CCB-1BF3

    it's the InstantDB java driver, then get DataBrowser from jmatrix.net

    Start DataBrowser like so: java -jar databrowser.jar

    Go Edit -> Edit Preferences -> Driver Manager -> Add, and add the idb-2.jar driver you downloaded above.

    Then, go Database -> New Connection -> Instant DB, and browser to wherever your .db file is.

    Let me know if this works, I don't have an example file to try out.

    • 1