Thread: Calibre Metadata.DB on two machines
View Single Post
Old 07-09-2009, 12:22 PM   #2
Format C:
Guru
Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.
 
Posts: 753
Karma: 1496807
Join Date: Jul 2008
Location: The Third World
Device: iLiad + PRS-505 + Kindle 3
Quote:
Originally Posted by chaznsc View Post
I have two machines sharing a library, or rather, supposed to be sharing a library. I have 2 of the metadata.db files in the root of thelibrary, one called out as specific to one machines name.

Is there any way to combine these and only use one db so the files are the same?

chaz
It's possible, but it requires a few scripting skill.
Basically, you have to append tp one DB the result of a selecty on the other, renumbering the items (BOOKS, AUTHORS, TAGS, PUBLISHERS, etc...) so that primary and foreign keys are not violated.
It's doable applying an offset to each ID.
Format C: is offline   Reply With Quote