library.db doesn't migrate?

[NigelS]

Just installed the new version 84 (fresh install) on a Vista PC. I pointed calibre at \Documents\My Books\Calibre for the storage folder, where I had placed a copy of library.db that I wanted to migrate across.

However, despite the dialog saying that library.db would be migrated across to the new database; nothing actually happened.

How do I now import/migrate the contents of library.db across from my old installation?

Thanks
NigelS

[kovidgoyal]

The migration happens automatically you dont need to move library1.db. Just find and delete a folder called calibre in which there is a file global.py

Then delete and recreate the folder \Documents\My Books\Calibre

Leave library1.db in its old location and run calibre. It will ask you for a new folder location at which time you specify \Documents\My Books\Calibre

[NigelS]

Ok Thanks, I'll play around some more.

I did try and upgrade the old version in situ (in a WinXP virtual machine) and that migrated OK.

It did however, create bookname subfolders in the form: bookname (x) - where X was an increasing integer. Is there any reason it does this (ie append the number in parentheses)? I find it rather annoying and wish it didn't - is there anyway to edit the filepath that is stored in the meta db?

Thanks
NigelS

[kovidgoyal]

There is a reason (data integrity) and no you can't get rid of it.

[don1011]

Just installed the new version .86 on XP and the conversion stop at 5%.

[kovidgoyal]

Hmm is there a particular book it stops at?

[don1011]

Probably

[kovidgoyal]

the conversion progress dialog should tell you what boko it's stopping at

[don1011]

How can i identify and delete that corrupted book if calibre does not open

[kovidgoyal]

I'll tell you how if you canc onfirm it is indeed a single book.

[don1011]

in the new folder books/calibre i have a folder with no book inside. I suppose that it is the corrupted book.

[don1011]

I have deleted the folder with no book inside but still the same problem. I have also deleted the metadata db in the folder before my test

[kovidgoyal]

Delete the books folder (i.e. the folder that used to contain/contains metadata.db) THe delete the folder named calibre that contains global.py (you might have to do a search on your computer for global.py). Then run calibre. It should start trying to migrate the database again. Wath the progress dialog and note what book it stops at. Once you have the book name, I will tell you how to remove that book from the old database and redo the migration

[don1011]

Let"s suppose that i have the name of the book contaminated. How do i remove it from the old database?

[kovidgoyal]

calibre-debug -c "from calibre.library.database import LibraryDatabase; db = LibraryDatabase('library1.db'); db.refresh('title', True); import pprint; pprint.pprint(db.data)"

replace library1.db witht he full path to library1.db

This will print out all the books in the database with their id numbers. Once you have the id number for the problem book:

calibre-debug -c "from calibre.library.database import LibraryDatabase; db = LibraryDatabase('library1.db'); db.refresh('title', True); db.delete_book(id)"