Delete Database file?

[Boudewijn]

Can you access the old database with a sqlite-tool? Maybe there's an option to dump tables to text and import it to the new one. Of course, work on a copy of the original database.

Best regards,

Boudewijn


On November 19, 2016 12:34:35 PM GMT+01:00, Mick Sulley <mick at sulley.info> wrote:
>I have run self check on the disk and it seems fine.
>
>
>On 17/11/16 21:26, Maik Qualmann wrote:
>> I think you should first check their hard drive. It is well possible
>that it
>> has defective sectors. It would be a possible explanation for the
>broken
>> digiKam DB.
>>
>> Maik
>>
>> On Donnerstag, 17. November 2016 21:20:30 CET Mick Sulley wrote:
>>> I seem to have some corruption of my database (sqlite), some
>pictures do
>>> not display in Digikam.
>>>
>>> I just renamed my database and restarted Digikam (4.14) and it
>recreated
>>> the database, but the old file was 72.7 MB and the new one is 14.4
>MB.
>>> The missing pictures do now display.
>>>
>>> I have checked through some of the tables and there are big
>differences
>>> in numbers, e.g. ImageMetadata 46,949 records in the old table,
>21,310
>>> in the new table.
>>>
>>> I feel that to be safe and not loose data I need to restore the old
>>> database.  Any comments, advise?  I have loads of tags and I really
>>> don't want to loose them and see no easy way to confirm that they
>are
>>> all there.
>>>
>>> Thanks
>>>
>>> Mick
>>

-- 
Sent without keyboard or normal screen, hence lacking spelling, grammar and layout in greater doses than usually
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20161121/66e95c05/attachment.html>