[Digikam-users] How to move a digikam collection

[Thomas]

2012/6/26 Jim Householder <nofixed at westnet.com.au>

> On 06/25/12 06:10, Jean-François Rabasse wrote:
>
>>
>> Hi Thomas,
>>
>> On Sun, 24 Jun 2012, Thomas wrote:
>>
>>  So, now my question is, how do I get this all up and running again
>>> with the collection in the new location and digikam on a new computer?
>>>
>>> I see that the SQL dump of digikam4.db has this line:
>>> INSERT INTO "AlbumRoots"
>>> VALUES(8,'photos',0,1,'**volumeid:?path=%2Fphotodisk%**
>>> 2Ftdn-photos%2Fphotos','/');
>>>
>>>
>>> Should I just change this to:
>>> INSERT INTO "AlbumRoots"
>>> VALUES(8,'photos',0,1,'**volumeid:?path=%2Fnet%2Fphoto%**2Fphotos','/');
>>> And then restore the digikam db?
>>>
>>
>> Seems good. That kind of tweak works for me, I have similar problems
>> when replicating (rsync) DK database between two computers, a desktop
>> and a laptop, and yes, I have to change the path of the collection
>> base directory.
>> A simple command line SQL command can do "UPDATE TABLE ... " etc.
>>
>> One more thing you should check is the location of your DB file, the
>> digikam4.db, because it's stored into the DK runtime configuration
>> file, $HOME/.kde4/share/config/**digikamrc
>> If your DB file is stored at the root of your collection, you'll
>> also have to change the "Database Name=" parameter from, e.g.
>> /photodisk/photos to /net/photo/photos, so that DK can find your new DB
>> upon next startup.
>>
>> And if your DB file is on your local computer, not on a USB drive or
>> network drive, of course nothing to change in rc configuration.
>>
>>
>>
>> Regards,
>> Jean-François
>>
>
> I'm not sure about the latest version of digiKam, but I think if you want
> the database on NAS you need to use mysql.
>
> ______________________________**_________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/**listinfo/digikam-users<https://mail.kde.org/mailman/listinfo/digikam-users>
>


Why is that?
I see that I get extremely many errors such as these:
digikam(12860)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::checkRetrySQLiteLockError: Database is
locked. Waited 1240
digikam(12860)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::checkRetrySQLiteLockError: Database is
locked. Waited 1250
digikam(12860)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::checkRetrySQLiteLockError: Database is
locked. Waited 1260
digikam(12860)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::checkRetrySQLiteLockError: Database is
locked. Waited 1270
digikam(12860)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::checkRetrySQLiteLockError: Database is
locked. Waited 1280


However, the *database* (digikam4.db) is *not* located on network
filesystem. Only the photos are.
I do not understand why this should be a problem.


Regards,
Thomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20120626/c2d5c293/attachment.html>