Firstly, it definitely not recommended to copy the database from one device to another. People have done it with mixed results, but, it isn't a recommended procedure.
This has been discussed several time over the years and I recommend searching for them for more details. But the basic choices are:
- Copy the complete database between the devices. The books have to be in exactly the same place. There are keys in the database that might prevent this from working properly.
- Copy the database but replace the contents of the table user with the data from the new device. Again the books have to be in exactly the same place.
- Add the books to the new device and let it import them. Again, the books have to be in the same place. Then export the data from the bookmarks table one one device and import it in the other. This won't get the reading status and other history, but it gets the bookmarks. If you do want to rearrange the file structure of the books, you can edit the exported data, but you need to make sure you get it right.
- For the reading status, if you use calibre, you can use my Kobo Utilities plugin to store the reading status of all books and then restore it later. This doesn't store the hours read, just the status. This doesn't need the books to be in the same place.
Of these, the only one I know that will work all the time is the last one. The others have been reported as working, but I've never needed to try them. The export of the bookmarks table should work with no problems.
|