What am I doing wrong (Re: moving the library to another computer).

[Marok]

I am trying to copy a working Calibre library onto another computer (which already has a smaller, working, Calibre library).
I burnt ALL folders and files (including metadata.db and metadata.opf) from the library to discs (2 dvds).
I created a new folder (same name as from the 1st computer, and different to the receiving one) on the 2nd computer and copied ALL folders and files from the dvds into it.
I used the Switch/Create library button to bring up the 'Choose your Calibre library' window.
In the 'New Location' box, I browsed to the new folder and selected it.
Calibre gives me an Unhandled exception error (full error message below), and the library wont open.
I tried all 3 radio button options in this window with the same result.

I even tried re-burning the library again, and re-copying across, but I got the same error message.
Someone on here suggested that I ensure that the files are not 'Read only', after the copy from dvd, which I have done.

The library is still working perfectly on the original machine.
If someone can tell me what I'm doing wrong, I'd be eternally grateful.


-------------------------------------------------------

***Error Message***
calibre, version 0.8.18
ERROR: Unhandled exception: <b>DatabaseException</b>:file is encrypted or is not a database
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 248, in run
File "site-packages\calibre\library\sqlite.py", line 226, in connect
DatabaseError: file is encrypted or is not a database

Traceback (most recent call last):
File "site-packages\calibre\gui2\__init__.py", line 315, in dispatch
File "site-packages\calibre\gui2\actions\choose_library.py", line 414, in switch_requested
File "site-packages\calibre\gui2\ui.py", line 487, in library_moved
File "site-packages\calibre\library\database2.py", line 193, in __init__
File "site-packages\calibre\library\database2.py", line 144, in connect
File "site-packages\calibre\library\sqlite.py", line 366, in connect
DatabaseException: file is encrypted or is not a database
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 248, in run
File "site-packages\calibre\library\sqlite.py", line 226, in connect
DatabaseError: file is encrypted or is not a database

[pete_1967]

Originally Posted by Marok

file is encrypted or is not a database

What OS are you using? In any case, you are not trying to move the directory from an encrypted drive to non-encrypted one? It's easy to forget that you might have encrypted your drive if it is automatically mounted on login.

Another thing I'd try is to just copy the old directories directly to Calibre's default location and see what happens then.

[kennyc]

Same O/S? Same version? 64/32 etc. Same version of Calibre?

[theducks]

Burning to DVD makes all files read only. You need to clear that flag on the files, once you have copied to a new disk.

Zip up you old Library, then burn the Zip to the DVD (WinRAR can set the spanned archive size so each piece will fit on a DVD).
The Read flag does not change for files inside an archive

[Marok]

Thanks for the fast replies, people.

The drive I'm copying from is definitely not encrypted.
Source and destination Calibre's are the same version.
Copying from Windows 7 (64 bit) to Windows 7 (possibly 32 bit - not sure - it's not my computer).
Could the (possible) 32 bit Windows be the issue here?

[PeterT]

Check the read only attribute on the files... Open a command prompt, change to the directory where the metadata.db is and do a

attrib -r *.* /s

This will remove the read only attribute from all files.

[kennyc]

I don't know about the 32/64 thing, but I do know I've copied my calibre library from my win7-64 to and XP (acer netbook) without issues, but it was/is a direct copy via network.