Export Pictures and Database to a different PC

classic Classic list List threaded Threaded
13 messages Options
Reply | Threaded
Open this post in threaded view
|

Export Pictures and Database to a different PC

Sebastian Pfohl
Hello. Im new to DigiKam. Im using it under Windows 32. Since i have more than one PC, i want to know, if it is possible to transfer Pictures and Database to another PC, so that i can use the same Level on a other PC. Ist it possible and what must i do?

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

smime.p7s (2K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Bugzilla from nicolasmf@gmail.com
Hello,

I'm not using dk on windows, but I think somer general rules may apply. It is indeed possible to transfer anything, but I haven't fully understood what your goal is: migrating everything to another PC or working from diferent PCs simultaneously?

- if migrating is meant, the tricky bit might be keeping your ratings, labels etc (metadata in general). There have been discussions about this not long ago, you might want to look at past emails. What I'd say: write all metadata to the image to have the opportunity to rebuild your database by reading them if something goes wrong.

- if the second, you'd want to use one PC as a server. Digikam can connect to both a remote collection and remote database.

I'm no expert, but there are quite a few around here which might provide more help if you need more specific answers.

Nicolas


On Sat, Jan 25, 2014 at 6:32 PM, Sebastian Pfohl <[hidden email]> wrote:
Hello. Im new to DigiKam. Im using it under Windows 32. Since i have more than one PC, i want to know, if it is possible to transfer Pictures and Database to another PC, so that i can use the same Level on a other PC. Ist it possible and what must i do?

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users



_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Sebastian Pfohl
The Point is, i have a Collection on Photos on PC1 with Windows Vista. I must make there some changes to this Collection. After this, i will move this with all new Metadata, Album and so on to a new PC with either Windows 8 or Windows 7.

Maybe, there will be a Day, where i need to Work on this Collection with both PC's. So it sounds, that the second thing is more for me. If it is possible to store both, the Database and the Collection on a Netshare (SMB, FTP), this could be the better solution. Its possible to save my files on a SMB Share from my Router (AVM FritzBox), so i can access them from both PC's. It must be not possible to use them on the same time.

Date: Mon, 27 Jan 2014 07:02:51 +0100
From: [hidden email]
To: [hidden email]
Subject: Re: [Digikam-users] Export Pictures and Database to a different PC

Hello,

I'm not using dk on windows, but I think somer general rules may apply. It is indeed possible to transfer anything, but I haven't fully understood what your goal is: migrating everything to another PC or working from diferent PCs simultaneously?

- if migrating is meant, the tricky bit might be keeping your ratings, labels etc (metadata in general). There have been discussions about this not long ago, you might want to look at past emails. What I'd say: write all metadata to the image to have the opportunity to rebuild your database by reading them if something goes wrong.

- if the second, you'd want to use one PC as a server. Digikam can connect to both a remote collection and remote database.

I'm no expert, but there are quite a few around here which might provide more help if you need more specific answers.

Nicolas


On Sat, Jan 25, 2014 at 6:32 PM, Sebastian Pfohl <[hidden email]> wrote:
Hello. Im new to DigiKam. Im using it under Windows 32. Since i have more than one PC, i want to know, if it is possible to transfer Pictures and Database to another PC, so that i can use the same Level on a other PC. Ist it possible and what must i do?

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users



_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Andrew Goodbody-2
It is possible to move the photos and database to another PC.

Part of the difficulty lies in the, IMHO, poor design decision to write
the path to the collection into the database. This may include a GUID of
the HDD on which it originally resided. So even if you recreate the path
including the drive letter on the new PC you may still have problems
unless you manually edit the database entry involved.

You can indeed have the photos on a netshare as a remote collection. The
situation with the database is more complicated however. If you use
sqlite then the database must be on a local drive for the PC accessing
it ie no network at all. If you use MySQL then you can have a remote PC
running the db as a server. However this implementation is not yet bug
free so use at your own risk.

Andrew

On 27/01/14 06:33, Sebastian Pfohl wrote:

> The Point is, i have a Collection on Photos on PC1 with Windows Vista. I
> must make there some changes to this Collection. After this, i will move
> this with all new Metadata, Album and so on to a new PC with either
> Windows 8 or Windows 7.
>
> Maybe, there will be a Day, where i need to Work on this Collection with
> both PC's. So it sounds, that the second thing is more for me. If it is
> possible to store both, the Database and the Collection on a Netshare
> (SMB, FTP), this could be the better solution. Its possible to save my
> files on a SMB Share from my Router (AVM FritzBox), so i can access them
> from both PC's. It must be not possible to use them on the same time.
> ------------------------------------------------------------------------
> Date: Mon, 27 Jan 2014 07:02:51 +0100
> From: [hidden email]
> To: [hidden email]
> Subject: Re: [Digikam-users] Export Pictures and Database to a different PC
>
> Hello,
>
> I'm not using dk on windows, but I think somer general rules may apply.
> It is indeed possible to transfer anything, but I haven't fully
> understood what your goal is: migrating everything to another PC or
> working from diferent PCs simultaneously?
>
> - if migrating is meant, the tricky bit might be keeping your ratings,
> labels etc (metadata in general). There have been discussions about this
> not long ago, you might want to look at past emails. What I'd say: write
> all metadata to the image to have the opportunity to rebuild your
> database by reading them if something goes wrong.
>
> - if the second, you'd want to use one PC as a server. Digikam can
> connect to both a remote collection and remote database.
>
> I'm no expert, but there are quite a few around here which might provide
> more help if you need more specific answers.
>
> Nicolas
>
>
> On Sat, Jan 25, 2014 at 6:32 PM, Sebastian Pfohl <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     Hello. Im new to DigiKam. Im using it under Windows 32. Since i have
>     more than one PC, i want to know, if it is possible to transfer
>     Pictures and Database to another PC, so that i can use the same
>     Level on a other PC. Ist it possible and what must i do?
>
>     _______________________________________________
>     Digikam-users mailing list
>     [hidden email] <mailto:[hidden email]>
>     https://mail.kde.org/mailman/listinfo/digikam-users
>
>
>
> _______________________________________________ Digikam-users mailing
> list [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Mick Sulley
In reply to this post by Sebastian Pfohl
I have pictures duplicated on laptop and desktop, plus I have a server.  What I do is to synchronise them to the server, so a change on laptop gets copied to the server when I sync, then to the desktop when I sync that.  For DigiKam everything (pictures, thumbnails and database) is in the directory that you  specify as the album, so transfer is easy.  It can take a little while to start DigiKam after a change as it looks for new content but it all works fine.  You could do this with a straight sync between two machines, and if it is just a one off to move it all then just copy the whole directory across.

I do it all on Linux but I am sure you can do the same on Windows

Mick


On 27/01/14 06:33, Sebastian Pfohl wrote:
The Point is, i have a Collection on Photos on PC1 with Windows Vista. I must make there some changes to this Collection. After this, i will move this with all new Metadata, Album and so on to a new PC with either Windows 8 or Windows 7.

Maybe, there will be a Day, where i need to Work on this Collection with both PC's. So it sounds, that the second thing is more for me. If it is possible to store both, the Database and the Collection on a Netshare (SMB, FTP), this could be the better solution. Its possible to save my files on a SMB Share from my Router (AVM FritzBox), so i can access them from both PC's. It must be not possible to use them on the same time.

Date: Mon, 27 Jan 2014 07:02:51 +0100
From: [hidden email]
To: [hidden email]
Subject: Re: [Digikam-users] Export Pictures and Database to a different PC

Hello,

I'm not using dk on windows, but I think somer general rules may apply. It is indeed possible to transfer anything, but I haven't fully understood what your goal is: migrating everything to another PC or working from diferent PCs simultaneously?

- if migrating is meant, the tricky bit might be keeping your ratings, labels etc (metadata in general). There have been discussions about this not long ago, you might want to look at past emails. What I'd say: write all metadata to the image to have the opportunity to rebuild your database by reading them if something goes wrong.

- if the second, you'd want to use one PC as a server. Digikam can connect to both a remote collection and remote database.

I'm no expert, but there are quite a few around here which might provide more help if you need more specific answers.

Nicolas


On Sat, Jan 25, 2014 at 6:32 PM, Sebastian Pfohl <[hidden email]> wrote:
Hello. Im new to DigiKam. Im using it under Windows 32. Since i have more than one PC, i want to know, if it is possible to transfer Pictures and Database to another PC, so that i can use the same Level on a other PC. Ist it possible and what must i do?

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users



_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Hans Muecke
In reply to this post by Sebastian Pfohl
Am 25.01.2014 17:32, schrieb Sebastian Pfohl:

> Hello. Im new to DigiKam. Im using it under Windows 32. Since i have
> more than one PC, i want to know, if it is possible to transfer Pictures
> and Database to another PC, so that i can use the same Level on a other
> PC. Ist it possible and what must i do?

Hi Sebastian,

From my understanding you are staying "on Windows" ... I have no
experience with that.

When on vacation I travel with a Win7 notebook (Digikam 3.? installed).
After returning home I transfer the pictures to the main machine (Ubuntu
12.04.3 LTS running Digikam 2.6) ... all the data like tags, geolocation
etc. are flawlesly imported. I never transfered the database, since it
is automatically created by the receiving machine.

Not sure if that helps ...

--
Talk to you later ... Hans (237 to go)

2014/01/27 17:20
EDDS 271720Z 23003KT CAVOK 01/M00 Q0999 NOSIG
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

jdd@dodin.org
Hello,

I think DigiKam miss some rules/info regarding the database location and photo
albums. This have little importance for the usual install, but have a heavy
one when migrating or copying.

one of the reasons is that it do not sems possible to *exclude* a folder from
being use by DigiKam.

I mean, if you have folders

medias
   photo1
   photo2
   video
   Audio

and if you choose "media" as collection location, it's not possible to say
"video" and "audio" do not have to be indexed by digiKam. It may be solved by
links, but links are always confusing, specially when a copy is planned.

si one have to keep all the digiKam photos and these only in a sub tree, say:

digiKam
   photo1
   photo2

in this situation, the (sqlite) database can be located in the digiKam folder
and archived pretty easily

an other way could be to allow one database per collection

jdd

--
http://www.dodin.org
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Hans Muecke
Am 27.01.2014 18:04, schrieb jdd:

> Hello,
>
> I think DigiKam miss some rules/info regarding the database location and
> photo albums. This have little importance for the usual install, but
> have a heavy one when migrating or copying.
>
> one of the reasons is that it do not sems possible to *exclude* a folder
> from being use by DigiKam.
>
> I mean, if you have folders
>
> medias
>   photo1
>   photo2
>   video
>   Audio
>
> and if you choose "media" as collection location, it's not possible to
> say "video" and "audio" do not have to be indexed by digiKam. It may be
> solved by links, but links are always confusing, specially when a copy
> is planned.
>
> si one have to keep all the digiKam photos and these only in a sub tree,
> say:
>
> digiKam
>   photo1
>   photo2
>
> in this situation, the (sqlite) database can be located in the digiKam
> folder and archived pretty easily
>
> an other way could be to allow one database per collection

Ok ... since I only copy what I have on a different machine to the same
tree on the main machine, that might be the reason, why it works on my end.

--
Talk to you later ... Hans (237 to go)


2014/01/27 18:50
EDDS 271850Z 09006KT CAVOK M00/M02 Q1000 NOSIG
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Sebastian Pfohl
I will try to migrate my SQLite DB to a MySQL DB. Either with XAMPP or on my vServer and put the Collection on a virtual  Windows Share. Yesterday i have tried to install MySQL on my Router, but this fails, because a Router have not enough CPU and Memory to hold all the needed things. Maybe i can use the SMB Share on the Router to hold only the Collection and not additionaly the Database.

Mit freundlichen Grüßen
Sebastian Pfohl
pfohl://NET

E-Mail:[hidden email]
Internet: http://www.pfohlnet.de

Der Absender kann für durch Schadprogramme entstandene Schäden, die über diese E-Mail übermittelt worden sind, nicht haftbar gemacht werden.


> Date: Mon, 27 Jan 2014 19:27:13 +0000

> From: [hidden email]
> To: [hidden email]
> Subject: Re: [Digikam-users] Export Pictures and Database to a different PC
>
> Am 27.01.2014 18:04, schrieb jdd:
> > Hello,
> >
> > I think DigiKam miss some rules/info regarding the database location and
> > photo albums. This have little importance for the usual install, but
> > have a heavy one when migrating or copying.
> >
> > one of the reasons is that it do not sems possible to *exclude* a folder
> > from being use by DigiKam.
> >
> > I mean, if you have folders
> >
> > medias
> > photo1
> > photo2
> > video
> > Audio
> >
> > and if you choose "media" as collection location, it's not possible to
> > say "video" and "audio" do not have to be indexed by digiKam. It may be
> > solved by links, but links are always confusing, specially when a copy
> > is planned.
> >
> > si one have to keep all the digiKam photos and these only in a sub tree,
> > say:
> >
> > digiKam
> > photo1
> > photo2
> >
> > in this situation, the (sqlite) database can be located in the digiKam
> > folder and archived pretty easily
> >
> > an other way could be to allow one database per collection
>
> Ok ... since I only copy what I have on a different machine to the same
> tree on the main machine, that might be the reason, why it works on my end.
>
> --
> Talk to you later ... Hans (237 to go)
>
>
> 2014/01/27 18:50
> EDDS 271850Z 09006KT CAVOK M00/M02 Q1000 NOSIG
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

kinnalru@gmail.com
In reply to this post by Sebastian Pfohl

Hello

I‘am using unison utility to make two-side synchronization between Windows and Linux through ssh on linux machine. Also unison can run as tcp-server and made all works on purely windows network.
Unison has nice gui an track state of all files(contents) so it is very effective when you move/rename files - they don‘t transmitted again but also uses move/rename on other side.
Be aware to use unison gui you must also install gtk-runtime on windows(i‘am installed it to the same folder as unison)

You can setup sheduling of unison on windows to made sync in background.

Best regards.

25.01.2014 21:32 пользователь "Sebastian Pfohl" <[hidden email]> написал:
Hello. Im new to DigiKam. Im using it under Windows 32. Since i have more than one PC, i want to know, if it is possible to transfer Pictures and Database to another PC, so that i can use the same Level on a other PC. Ist it possible and what must i do?

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

tosca
In reply to this post by Sebastian Pfohl
Not sure it's a very wise decision, as MySQL is still experimental on Digikam.

Marie-Noëlle


2014-01-28 Sebastian Pfohl <[hidden email]>

I will try to migrate my SQLite DB to a MySQL DB. Either with XAMPP or on my vServer and put the Collection on a virtual  Windows Share. Yesterday i have tried to install MySQL on my Router, but this fails, because a Router have not enough CPU and Memory to hold all the needed things. Maybe i can use the SMB Share on the Router to hold only the Collection and not additionaly the Database.






--

Retrouvez mon portfolio et mes activités dans ma galerie personnelle, mes reportages sur Jingoo
Et bien sûr la page Photographe en Cévennes sur FB, et mon compte Twitter.

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

Sebastian Pfohl
Hmm i will try it out and report after the Weekend. I fear do not have the time to test this under the week :-)



From: [hidden email]
Date: Tue, 28 Jan 2014 09:44:54 +0100
To: [hidden email]
Subject: Re: [Digikam-users] Export Pictures and Database to a different PC

Not sure it's a very wise decision, as MySQL is still experimental on Digikam.

Marie-Noëlle


2014-01-28 Sebastian Pfohl <[hidden email]>

I will try to migrate my SQLite DB to a MySQL DB. Either with XAMPP or on my vServer and put the Collection on a virtual  Windows Share. Yesterday i have tried to install MySQL on my Router, but this fails, because a Router have not enough CPU and Memory to hold all the needed things. Maybe i can use the SMB Share on the Router to hold only the Collection and not additionaly the Database.






--

Retrouvez mon portfolio et mes activités dans ma galerie personnelle, mes reportages sur Jingoo
Et bien sûr la page Photographe en Cévennes sur FB, et mon compte Twitter.

_______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Export Pictures and Database to a different PC

upscope
On Tuesday, January 28, 2014 07:05:37 PM Sebastian Pfohl wrote:
<Quote>

> Hmm i will try it out and report after the Weekend. I fear do not have
> the time to test this under the week :-)
>
>
> From: [hidden email]
> Date: Tue, 28 Jan 2014 09:44:54 +0100
> To: [hidden email]
> Subject: Re: [Digikam-users] Export Pictures and Database to a
> different PC
>
> Not sure it's a very wise decision, as MySQL is still experimental on
> Digikam.
>
> Marie-Noëlle
</Quote>

I have been using MySQL to save my albums since it first appeared in
Digikam setting, after figuring out correct password set up it has
worked without issue. even restored it about a month ago when I
installed a new os version on different disk.

I am talking Linux based, not sure about windows, since I do not use it
at all!

Russ
--
openSUSE 13.1(Linux 3.11.6-4-desktop x86_64|
Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3|
GeForce 8400GS (NVIDIA-Linux-x86_64-331.38)|KDE 4.12.1

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users