Thread: moving books and database from a device to another: a crazy thought?
View Single Post
Old 04-12-2014, 11:49 PM   #11
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by paola View Post
losing the reading position would not be a major problem, as the books I am currently reading are bought from Kobo, so I can always re-sync. What I am really keen upon is preserving the notes and highlights I have made on finished books, many of which were not kobo purchases.
Bookmarks for any purchased kepubs should be synced via the Kobo server. That includes any that you remove from the device but are still in your library shown on the Kobo site.

For sideloaded books, the bookmarks have to be copied from one device to the other somehow. Copying the database would work for this. But, I would dump the data from the Bookmarks table and then load that into the new device. As I said before, if the file paths for the books are identical on both devices, its easy. If they change, it needs a little extra work. But, it would probably be a good idea not to copy the bookmarks for the purchased kepubs. The following SQL statement will do what is needed:
Code:
SELECT * 
FROM Bookmark
WHERE VolumeID like 'file%'
AND NOT Hidden = 'true'
Running that against the database, dumping the results to a file and then importing them to the new database will copy the bookmarks for the sideloaded books.
Quote:
Actually, for some of them I have an additional problem - they were bought from Sony, but the whole sony library has now been transferred to Kobo: I wonder whether my Aura will see the old sideloaded kepub and the imported, original Kepub as two different books....
Yes, the device will see them as two different books. The database uses the books file name as the key when referring to the book. For the purchased kepubs, the file name is a GUID. Something like, "09953760-5b32-4d22-8d12-9e1c7177f26e". The firmware knows what directory to look in for these books. For sideloaded books, it is the full path as the firmware sees it. As an example, this is "file:///mnt/onboard/Bagley, Desmond/Landslide - Desmond Bagley.kepub.epub". If the Sony books get added to your Kobo library and downloaded to the device, they will appear in the library as kepubs with all the extras. The sideloaded versions will still be there.
davidfor is offline   Reply With Quote