Book Library integrity.

[Taeteck]

First of all, hi all

I'm amazed how well this software works, but i have a problem; maybe becouse of the way y use it

I have my library installed on two computers and add/edit info on both of them, and use a pendrive to keep both sync (using synctoy 2.1 on windows); but i noticed that i have books on calibre that has empty directories on the hard drive...

Also have couple of directories with cover and book, but they are not in calibre.

Is there a way to check the integrity of the database?

If not, it would be great to have some way to check/repair that.

Greetings from spain and thanks for all the work you all are doing.

[chaley]

Preferences -> Advanced -> Check database integrity

[itimpi]

You have to be very careful when doing this to keep the calibre database and the metadata.db files in sync on both machines. Make any mistakes and you will either have Calibre entries with missing ebook files, or ebook files with no Calibre entry.

A suggestion that might be worth trying is to keep your Master copy of the Calibre library on the PenDrive. You can make all your changes against that and then just sync to the PC(s) for backup purposes. Do not start forgetting to sync every so often if you go down this route as PenDrives are known to fail!

The attached batch file shows how to set up Calibre to run from the Pendrive, keeping all the library, metadata, binaries ahnd configuration information on the PenDrive. It also means you can use this on a machine that does not already have calibre installed as long as you are it is running Windows. You can use the samke technique for any other OS as long as you have the right batch/script file and correct binaries on the PenDrive.

[DoctorOhh]

Originally Posted by itimpi

A suggestion that might be worth trying is to keep your Master copy of the Calibre library on the PenDrive. You can make all your changes against that and then just sync to the PC(s) for backup purposes. Do not start forgetting to sync every so often if you go down this route as PenDrives are known to fail!

I concur, just update one main library then use sync to sync to backup locations.

[Taeteck]

Originally Posted by itimpi

You have to be very careful when doing this to keep the calibre database and the metadata.db files in sync on both machines. Make any mistakes and you will either have Calibre entries with missing ebook files, or ebook files with no Calibre entry.

A suggestion that might be worth trying is to keep your Master copy of the Calibre library on the PenDrive. You can make all your changes against that and then just sync to the PC(s) for backup purposes. Do not start forgetting to sync every so often if you go down this route as PenDrives are known to fail!

The attached batch file shows how to set up Calibre to run from the Pendrive, keeping all the library, metadata, binaries ahnd configuration information on the PenDrive. It also means you can use this on a machine that does not already have calibre installed as long as you are it is running Windows. You can use the samke technique for any other OS as long as you have the right batch/script file and correct binaries on the PenDrive.

Thank you very much, this seems to be one good solution for me