MobileRead Forums
Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre
Reload this Page Calibre Metadata.DB on two machines

Notices

Reply
 
Thread Tools Search this Thread
Old 07-09-2009, 12:18 PM   #1
chaznsc
Connoisseur
chaznsc began at the beginning.
 
chaznsc's Avatar
 
Posts: 70
Karma: 32
Join Date: Jul 2009
Device: Mine
Calibre Metadata.DB on two machines
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
chaznsc is offline   Reply With Quote
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
Advert
Old 07-09-2009, 12:23 PM   #3
chaznsc
Connoisseur
chaznsc began at the beginning.
 
chaznsc's Avatar
 
Posts: 70
Karma: 32
Join Date: Jul 2009
Device: Mine
Well, without combining these, can the two computers not SHARE the metadata file?
chaznsc is offline   Reply With Quote
Old 07-09-2009, 12:41 PM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,838
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You have to put the library on a network drive, try dropbox for example.
kovidgoyal is online now   Reply With Quote
Old 07-09-2009, 12:44 PM   #5
chaznsc
Connoisseur
chaznsc began at the beginning.
 
chaznsc's Avatar
 
Posts: 70
Karma: 32
Join Date: Jul 2009
Device: Mine
That's what I did, and the second machine created what the system calls "metadata (machine name's conflicted copy 2009-07-08).db"

Perhaps the original machine still had Calibre running, would that lock out system #2?
chaznsc is offline   Reply With Quote
Advert
Old 07-09-2009, 01:11 PM   #6
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,838
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You can only run one copy of calibre on a given database at a time.
kovidgoyal is online now   Reply With Quote
Old 07-09-2009, 01:15 PM   #7
chaznsc
Connoisseur
chaznsc began at the beginning.
 
chaznsc's Avatar
 
Posts: 70
Karma: 32
Join Date: Jul 2009
Device: Mine
OK, then as usual, its PEBKAC. Is there a setting to have Calibre actually close down rather than minimize to the tray?
chaznsc is offline   Reply With Quote
Old 07-09-2009, 03:01 PM   #8
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,838
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
yes there is, in preferences.
kovidgoyal is online now   Reply With Quote
Old 07-09-2009, 03:22 PM   #9
chaznsc
Connoisseur
chaznsc began at the beginning.
 
chaznsc's Avatar
 
Posts: 70
Karma: 32
Join Date: Jul 2009
Device: Mine
I will look again. Thanks for a fantastic resource!
chaznsc is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calibre GUI behavior between machines phenomshel Calibre 2 08-21-2010 06:28 PM
Calibre metadata.calibre not allowing updates Chuckels550 Calibre 10 08-09-2010 05:12 PM
Calibre Metadata JayLaFunk Calibre 2 06-17-2010 10:04 AM
Sony Vending Machines sUnShInE News 5 06-17-2006 11:05 AM
E-book vending machines? Bob Russell News 0 05-23-2006 06:55 PM


All times are GMT -4. The time now is 10:54 AM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.