View Single Post
Old 05-29-2011, 02:48 PM   #1
unboggling
Wizard
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,065
Karma: 858115
Join Date: Jan 2011
Device: Kobo Clara, Kindle Paperwhite 10
Corrupted OPF Files in large library

My database is corrupted. When I save books (writing metadata to opf) then import into a different library with the same structure, most of the data in user-defined fields doesn't come with it. Restore didn't help, probably made it worse.

This was my fault. I did things I shouldn't do. Changed fields in some libraries and not others. Copied books between libraries. Messed with permissions. Accessed the same library from 2 different computers thru my network while using same username. Moved library from ext HD to ext HD, used it from external HD from 2 computers. Migrated the library from computer1 to computer2 to computer3 without checking everything in between. Lost backups to stupidity. So a concatenation of things probably caused the problem(s).

I have the library on 1 computer now, changed all the permissions to "everyone rw" with one username as owner. But that didn't help. I'm presently transferring data from the user-defined fields to the Tags field, which seems to work for preserving the data in Tags thru the save and import. This will keep me busy at least several days and I'm still not sure all the records will save/import properly. It's a large library. When that's done I plan to import into a new library using just the calibre-supplied fields and work it from there.

Meanwhile, anyone have advice? Is there a relatively simple way to delete all the opf files in a copy of the library then regenerate them from metadata db? Though I'm not sure if/how corrupted metadata db is. I'm getting desperate. The idea of importing into a new database by file structure makes me shudder in dread at redoing so much work.

Thanks for any help.

-alan
unboggling is offline   Reply With Quote