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

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 01-06-2014, 05:14 PM   #1
kpetzing
Member
kpetzing began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Feb 2010
Device: none
Calibre move to new computer problem

I had several different libraries saved on my old computer's Calibre. I copied them to my new computer and all but one pulled in fine. The last one has a json file in the directory but no db file. So when I try to pull in those files I get an error. Is there any way to restore this? This was my main folder and had my personal ratings for many books and a couple added fields (tracking whether I read it, wanted to read, etc), so I'm really hoping theres some way to save it.

Thanks
kpetzing is offline   Reply With Quote
Old 01-06-2014, 05:39 PM   #2
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,124
Karma: 5735944
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Ubuntu Linux, Cybook Opus, Motorola Xoom with Mantano Premium
You need to find that db-file! If it is missing it might mean that the library isn't complete. Files missing...

However, if there are updated OPF-files along with the books, then the information is there as well. The OPF-files are a backup of the metadata that is stored in the database. So you could try to add the books to a new library, from the old. Make sure the new library has the same fields as your old library had.

You could try with one author, and see how it goes?

You would want to check in settings that metadata is read from the contents of the files, and not from the filenames.

Last edited by Adoby; 01-06-2014 at 05:43 PM.
Adoby is offline   Reply With Quote
 
Advertisement
Old 01-06-2014, 05:48 PM   #3
eschwartz
Irrational Optimist
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 8,364
Karma: 14838759
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
drop in a random db, so you can open in that folder, then a database restore from Library Management. It will completely reload the database from the metatata in the OPF backups, and the library settings from the metadata_db_prefs_backup.json
eschwartz is online now   Reply With Quote
Old 01-06-2014, 11:23 PM   #4
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,124
Karma: 5735944
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Ubuntu Linux, Cybook Opus, Motorola Xoom with Mantano Premium
Quote:
Originally Posted by eschwartz View Post
drop in a random db, so you can open in that folder, then a database restore from Library Management. It will completely reload the database from the metatata in the OPF backups, and the library settings from the metadata_db_prefs_backup.json
Wouldn't that cause metadata in previous custom columns to disappear, if the random db doesn’t have the exact same custom columns as what was stored in the opf-files?

It could be a good idea to test it, but make sure to have a backup of the corrupt library, if it seems that a complete restore of all metadata fails.

It assume it should be possible to examine a opf-file to find out what custom columns was used when the opf-file was created?
Adoby is offline   Reply With Quote
Old 01-06-2014, 11:33 PM   #5
eschwartz
Irrational Optimist
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 8,364
Karma: 14838759
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Quote:
Originally Posted by Adoby View Post
Wouldn't that cause metadata in previous custom columns to disappear, if the random db doesn’t have the exact same custom columns as what was stored in the opf-files?

It could be a good idea to test it, but make sure to have a backup of the corrupt library, if it seems that a complete restore of all metadata fails.

It assume it should be possible to examine a opf-file to find out what custom columns was used when the opf-file was created?
Excellent point about the backup. I think it should be all right -- the db "should" only update the backup json and opf's if changes are performed. But better safe than sorry.

By definition, the restore database function is supposed to completely trash the db and restore all info whatsoever from the backups. book metadata is stored in the opf, and the metadata_db_prefs_backup.json contains ALL other data saved in the db -- it is supposed to ensure that by combining the json with the opf's, all the data is saved by which the db can be restored literally from nonexistence. As is indeed the case here.

TL;DR The custom columns are created from metadata_db_prefs_backup.json, and given values, if available (and they had better be), from the opf.
eschwartz is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I move my library to a new computer? Baroness Calibre 1 12-10-2012 03:23 AM
Move Calibre to new computer my library isn't showing. Villordsutch Related Tools 4 09-12-2012 04:26 AM
Best way to move database to another computer lothlann Calibre 6 01-06-2011 05:03 PM
How do I move notes to computer? nguirado Amazon Kindle 8 12-27-2010 07:03 PM
using replicator software to move calibre folder to another computer dcarlozzi Calibre 15 07-02-2010 04:18 PM


All times are GMT -4. The time now is 03:35 PM.


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