<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi</p>
<p>does it mean that in DK6, the creation of the new db is not
automatic and not handled during the installation process ? is it
planned to be added for the release version?<br>
</p>
<p>(I'm using the default db SQLLite)</p>
<p>I'm altready using DK6 on Win10, where to execute the commands
you are talking about<br>
</p>
<p>I tried to run the maintenance but it doesn't change anything,
still seeing only 3 db files, and still don't find anyu button to
launch similarity search.<br>
</p>
<p>regards</p>
<p>frederic<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Le 23/12/2018 à 08:08, Phil Styles a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:002801d49a8e$4c9231f0$e5b695d0$@styles.me.uk">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;
mso-fareast-language:EN-US;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:90244634;
mso-list-template-ids:-2064383956;}
@list l1
{mso-list-id:661397096;
mso-list-type:hybrid;
mso-list-template-ids:1664368854 -1008046198 134807577 134807579 134807567 134807577 134807579 134807567 134807577 134807579;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:54.0pt;
text-indent:-18.0pt;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:90.0pt;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:126.0pt;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:162.0pt;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:198.0pt;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:234.0pt;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:270.0pt;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:306.0pt;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:342.0pt;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi Frederic<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">With 5.9.0 just create an empty database in
the same manner as the standard three databases e.g.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt">CREATE DATABASE
digikam_similarity;<br>
GRANT ALL PRIVILEGES ON digikam_similarity.* TO 'digikam'@'%';<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">After installing 6.0.0 the Database
Settings form has a new field to identify the “Similarity DB
Name”; change this to identify the similarity database created
previously<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ve yet to try any using this feature but
I believe you have to run “Maintenance” to ‘Find Duplicate
Items” and then you can use the “Find Duplicates” tool. I’m
sure more experienced digiKam users will correct me if I’m
wrong.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards, PhilTheHill<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="mso-fareast-language:EN-GB" lang="EN-US">From:</span></b><span
style="mso-fareast-language:EN-GB" lang="EN-US">
Digikam-users <a class="moz-txt-link-rfc2396E" href="mailto:digikam-users-bounces@kde.org"><digikam-users-bounces@kde.org></a> <b>On
Behalf Of </b>frederic chaume<br>
<b>Sent:</b> 22 December 2018 08:44<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:digikam-users@kde.org">digikam-users@kde.org</a><br>
<b>Subject:</b> Re: [digiKam-users] digikam 6.0.0
release<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi
PhilTheHill<span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">thanks
a lot for those guidelines<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I'm
currently running 6.0.0 Beta2 on windows 10 (default
configuration with sqllite), and I noticed you mentionned a
step 3 : Configure the new ‘Similarity Db’ <o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">can
you precise what need to be done? I currently tried to use
similarity , but didin't found any button in the inteface to
launch the search, could it come from missing this steps ?<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I
see effectively the recognition, digikam and thumbnails
databases , but not the similarity one<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I'm
joining to you to warmely thanks the digikam team to provide
us this excellent product.<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">and
Merry Christmas to yo<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">regards<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">frederic<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Le 21/12/2018 à 08:50, <a
href="mailto:digikam@styles.me.uk" moz-do-not-send="true">digikam@styles.me.uk</a>
a écrit :<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Having noticed that the release of
digiKam 6.0.0 is imminent according to the <a
href="https://www.digikam.org/documentation/releaseplan/"
moz-do-not-send="true">Release Plan</a> I thought I’d pen
a few words on the upgrade from a user viewpoint.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I’ve been quietly testing the 5.9.0 to
6.0.0 betas for some time now and as recent emails have
pointed out, there is a database upgrade involved.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">For a major release, this should be
expected and if you’re intending to use digiKam seriously,
you should already be backing up your database regularly but
especially before any upgrade, major or minor!!! I’m using
digiKam on Windows 10 with MariaDB on Centos 7 for the
database so this means running something like<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">mysqldump --add-drop-table -h 127.0.0.1
-u ${USER} -p${DB_PASSWORD} digikam_core | bzip2 -c
>~/backups/digikam_core.sql.bz2<o:p></o:p></p>
<p class="MsoNormal">mysqldump --add-drop-table -h 127.0.0.1
-u ${USER} -p${DB_PASSWORD} digikam_thumbs | bzip2 -c
>~/backups/digikam_thumbs.sql.bz2<o:p></o:p></p>
<p class="MsoNormal">mysqldump --add-drop-table -h 127.0.0.1
-u ${USER} -p${DB_PASSWORD} digikam_faces | bzip2 -c
>~/backups/digikam_faces.sql.bz2<o:p></o:p></p>
<p class="MsoNormal">mysqldump --add-drop-table -h 127.0.0.1
-u ${USER} -p${DB_PASSWORD} digikam_similarity | bzip2 -c
>~/backups/digikam_similarity.sql.bz2<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">You should note that there is a fourth
digicam_similarity database which is introduced with 6.0.0.
I would recommend creating an empty database on your 5.9.0
server which 5.9.0 will ignore but 6.0.0 will use (and it
will already be included in your backup scripts).<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">If you’re planning to test digiKam
seriously, create a digikam6 database owned by a different
user with a different password (which helps to minimise
‘accessing the wrong database’ problems) and restore the
5.9.0 databases for use by digiKam 6.0.0.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">bunzip2 -c
<~digikam/backups/digikam_core.sql.bz2 | mysql -h
127.0.0.1 -u ${USER} -p${DB_PASSWORD} digikam6_core<o:p></o:p></p>
<p class="MsoNormal">bunzip2 -c
<~digikam/backups/digikam_thumbs.sql.bz2 | mysql -h
127.0.0.1 -u ${USER} -p${DB_PASSWORD} digikam6_thumbs<o:p></o:p></p>
<p class="MsoNormal">bunzip2 -c
<~digikam/backups/digikam_faces.sql.bz2 | mysql -h
127.0.0.1 -u ${USER} -p${DB_PASSWORD} digikam6_faces<o:p></o:p></p>
<p class="MsoNormal">bunzip2 -c
<~digikam/backups/digikam_similarity.sql.bz2 | mysql -h
127.0.0.1 -u ${USER} -p${DB_PASSWORD} digikam6_similarity<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">For testing digiKam itself, use a second
system, either a physical system or a virtual machine and
NOT your live digiKam install!!! All software has bugs or
‘unexpected features’ and beta software often has even more;
expect problems and plan accordingly. On your test system,
install digKam 5.9.0 (or whatever version you’re currently
using), copy over digikamrc from your working installation
and edit it to refer to the 6.0.0 database. You’ve now
‘cloned’ your 5.9.0 install and database so test it works
and fix any problems before proceeding. You can then upgrade
your test 5.9.0 install to 6.0.0. as this tests the software
upgrade process for your setup.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">After upgrading your test install to
6.0.0 you can finally try it. What can you expect? Your
anti-virus software may object to unsigned programs so be
prepared to deal with this. From my observations, the first
time digKam 6.0.0 runs against a 5.9.0 database, it takes a
loooooooong time to startup which, given that there’s a
database upgrade, should be expected. Go and have a cup of
tea/coffee and give it time to finish! In addition, even
when digicam 6.0.0 appears ‘ready to use’ there are
background activities still in running so check both digicam
itself (task manager on Windows) and the database server
(top on Linux) are idle before trying to use digicam
seriously. Depending on your hardware and database size,
this may take a couple of hours.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I’ve used this process to test all the
recent betas without impacting my working 5.9.0 setup and,
encouragingly, have not encountered any major problems.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">If you’re not wanting to test the beta
releases, life is a little simpler so ….<o:p></o:p></p>
<ol style="margin-top:0cm" start="1" type="1">
<li class="MsoListParagraph"
style="margin-left:18.0pt;mso-list:l1 level1 lfo3">Backup
your current database, pictures and digikamrc to two
different places e.g. NAS and offline disk – anything
important should be stored in three different places<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:18.0pt;mso-list:l1 level1 lfo3">Install
the digiKam 6.0.0 software package and run it<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:18.0pt;mso-list:l1 level1 lfo3">Go for
a tea/coffee and check it’s finished. Then go for lunch
and check it’s really finished.<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:18.0pt;mso-list:l1 level1 lfo3">Configure
the new ‘Similarity Db’<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:18.0pt;mso-list:l1 level1 lfo3">Test
it! Thrash it!!! Run though all database maintenance
activities, check critical workflow functions as expected,
try new functionality and consider if performance is OK.<o:p></o:p></li>
</ol>
<p class="MsoNormal">Until you actually start using it for new
work, you can still revert to 5.9.0 (software and database)
and all you’ve lost is some time.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">And finally, thanks to all the hard work
by the digiKam team in producing an excellent product,
Respect earned!<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">PhilTheHill<o:p></o:p></p>
</blockquote>
</div>
</blockquote>
</body>
</html>