Database Corrupted

[karimnaguib]

I was recently working on a Calibre Portable Version on my external hard disk, the hard disk cable was disconnected while working on Calibre.

The next time I opened Calibre, this error shows up on startup:

calibre, version 1.34.0
تلف قاعدة البيانات: The library database at G:\Calibre Portable extra\Calibre Library extra appears to be corrupted. Do you want calibre to try and rebuild it automatically? The rebuild may not be completely successful. If you say No, a new empty calibre library will be created.

Traceback (most recent call last):
File "site-packages\calibre\gui2\main.py", line 249, in initialize_db
File "site-packages\calibre\db\legacy.py", line 70, in __init__
File "site-packages\calibre\db\legacy.py", line 44, in create_backend
File "site-packages\calibre\db\backend.py", line 375, in __init__
File "site-packages\calibre\db\backend.py", line 382, in initialize_prefs
File "site-packages\calibre\db\backend.py", line 74, in __init__
File "site-packages\calibre\db\backend.py", line 78, in load_from_db
File "site-packages\calibre\db\backend.py", line 278, in get
File "c:\cygwin\home\kovid\sw\build\apsw-3.7.17-r1\src\cursor.c", line 231, in resetcursor
CorruptError: CorruptError: database disk image is malformed


I tried restoring but I get this error after 2 hours:

Traceback (most recent call last):
File "site-packages\calibre\db\restore.py", line 125, in run
File "site-packages\calibre\db\restore.py", line 277, in replace_db
WindowsError: [Error32] The process cannot access the file because it is being used by another process

Any help with this ?
I have been working on this library for 2 years now and a lot of books, around 6000+
I really cannot afford to re-enter all this data.

[kovidgoyal]

shutdown your antivirus and make sure no other program is accessing the calibre library. move the library onto an internal disk. Repair it, and move it back.

[karimnaguib]

Thank you a million, worked only by closing my antivirus and restoring !