View Single Post
Old 05-06-2011, 03:54 PM   #38
larka2006
Edge User
 
Quote:
Originally Posted by kenjennings View Post
In continuation: Been root'ing (pun intended) around some more in the database.

It looks like /fridge is everything important about the device. So far, I see one table that appears to have the serialno value that identifies the device. In theory, I think updating this value to the target eDGe's serialno may make the backup restorable to a different edge.

** DISCLAIMER ** Completely untested by me, since I do not have a second edge for the purposes of research or torture. I'm only reporting what the data suggests may be possible. Your mileage will vary. Make sure you have an entirely separate backup and are willing to do a factory reset. I apologize in advance for the mayhem that will probably ensue, but I did warn you, right???

Requirements:
Be able to move a backup file to another PC.
Be able to run zip and unzip to uncompress/recompress the backup on a PC.
Have and be able to run sqlite3.

1) Determine the device ID/serialno of the TARGET edge. This is the serialno with the barcode on the "binding" edge of the closed edge like this: F303082002AF (No, not my actual serialno).

2) Do a backup on the source edge.

3) Copy the backup to another PC, unpack the zip file.

4) go to /fridge/.edge/.esi-data/.databases

5) run sqlite3 library.db

6) in sqllite execute the command: update esimeta set device = 'F303082002AF' where _id = 1 ;

7) quit sqllite, and rezip the directories /fridge and /sdcard (or /extsdcard if that was unpacked.) Alternatively, you may be able to just freshen the zip archive with only the library.db file

8) move the backup file to the target edge.

9) try to restore, cross fingers, get ready for disappointment, etc.
Did just as kenjennings suggested, and was using SqLite3 to fix device SN, have not go through for me, after restoring "fixed" file to another PE, got this message "Invalid Backup file - There was an error verifying your back up file. Please, try again latter." But all files are perfectly visible on PC. New PE just not see files in sdcard folder... After I removed "." before folder names on PC, and opened it from usb-flash on new PE, all files are visible, so PDFs, journals, etc could be moved to another PE and added to the library. I was able to add journals to new library and update/rename them. I don't have a lot of Journals, so this works and this is comforting to know that some data can be saved. Maybe the reason backup was not recognized is that it was created on Dingo PE and put on ERmine PE, at least it didn't say "it was created on another device" as it was before "sql-ing" library.db...