LC_MESSAGES/setup_application/database_settings.po

0001 #
0002 msgid ""
0003 msgstr ""
0004 "Project-Id-Version: Digikam Manual 8.0.0\n"
0005 "Report-Msgid-Bugs-To: \n"
0006 "POT-Creation-Date: 2023-12-30 00:35+0000\n"
0007 "PO-Revision-Date: 2022-12-29 18:31+0100\n"
0008 "Last-Translator: KDE Francophone <kde-francophone@kde.org>\n"
0009 "Language-Team: French <kde-francophone@kde.org>\n"
0010 "Language: fr\n"
0011 "MIME-Version: 1.0\n"
0012 "Content-Type: text/plain; charset=UTF-8\n"
0013 "Content-Transfer-Encoding: 8bit\n"
0014 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
0015
0016 #: ../../setup_application/database_settings.rst:1
0017 msgid "digiKam Database Settings"
0018 msgstr ""
0019
0020 #: ../../setup_application/database_settings.rst:1
0021 msgid ""
0022 "digiKam, documentation, user manual, photo management, open source, free, "
0023 "learn, easy, database, setup, mysql, mariadb, sqlite, migration, local, "
0024 "remote, server"
0025 msgstr ""
0026
0027 #: ../../setup_application/database_settings.rst:14
0028 msgid "Database Settings"
0029 msgstr ""
0030
0031 #: ../../setup_application/database_settings.rst:16
0032 msgid "Contents"
0033 msgstr ""
0034
0035 #: ../../setup_application/database_settings.rst:20
0036 msgid ""
0037 "For an introduction of internal data storage, please refer to :ref:"
0038 "`Introduction of digiKam Databases <database_intro>` section."
0039 msgstr ""
0040
0041 #: ../../setup_application/database_settings.rst:25
0042 msgid "The Sqlite Database"
0043 msgstr ""
0044
0045 #: ../../setup_application/database_settings.rst:27
0046 msgid ""
0047 "`SQLite <https://sqlite.org/>`_ is a relational database management system, "
0048 "written in C programming library. SQLite is not directly comparable to "
0049 "client/server SQL database engines such as MySQL, Oracle or PostgreSQL. "
0050 "Rather, it is an embedded SQL database engine, i.e. it is embedded in an end "
0051 "program. SQLite reads and writes directly to ordinary disk files. For device-"
0052 "local storage with low writer concurrency and less than a terabyte of "
0053 "content, SQLite is almost always a better solution. SQLite is fast and "
0054 "reliable and it requires no configuration or maintenance. It keeps things "
0055 "simple. SQLite \"just works\"."
0056 msgstr ""
0057
0058 #: ../../setup_application/database_settings.rst:29
0059 msgid ""
0060 "By default, digiKam uses SQLite as its back-end for storing important "
0061 "metadata and thumbnails. Three SQLite files used for storing them are named "
0062 "respectively:"
0063 msgstr ""
0064
0065 #: ../../setup_application/database_settings.rst:32
0066 msgid "Database"
0067 msgstr ""
0068
0069 #: ../../setup_application/database_settings.rst:32
0070 msgid "File-Name"
0071 msgstr ""
0072
0073 #: ../../setup_application/database_settings.rst:34
0074 msgid "**Core**"
0075 msgstr ""
0076
0077 #: ../../setup_application/database_settings.rst:34
0078 msgid ":file:`digikam4.db`"
0079 msgstr ""
0080
0081 #: ../../setup_application/database_settings.rst:35
0082 msgid "**Thumbs**"
0083 msgstr ""
0084
0085 #: ../../setup_application/database_settings.rst:35
0086 msgid ":file:`thumbnails-digikam.db`"
0087 msgstr ""
0088
0089 #: ../../setup_application/database_settings.rst:36
0090 msgid "**Similarity**"
0091 msgstr ""
0092
0093 #: ../../setup_application/database_settings.rst:36
0094 msgid ":file:`similarity.db`"
0095 msgstr ""
0096
0097 #: ../../setup_application/database_settings.rst:37
0098 msgid "**Faces**"
0099 msgstr ""
0100
0101 #: ../../setup_application/database_settings.rst:37
0102 msgid ":file:`recognition.db`"
0103 msgstr ""
0104
0105 #: ../../setup_application/database_settings.rst:40
0106 msgid ""
0107 "To make your application run fast and smoothly, it is recommended to check "
0108 "and optimize your databases once in awhile. This could be achieved with the "
0109 "menu option :menuselection:`Tools --> Maintenance...` and the stage "
0110 "**Perform Database Cleaning**. See this :ref:`Maintenance tool section "
0111 "<maintenance_database>` for details. A recommended tool is `SQLite Browser "
0112 "<https://sqlitebrowser.org/>`_, a high quality and easy to use visual tool "
0113 "for managing database objects. For Ubuntu and its derivatives, it could be "
0114 "retrieved using `sudo apt install sqlitebrowser`. Now you can switch to the "
0115 "directory where databases are stored and visualize the database contents."
0116 msgstr ""
0117
0118 #: ../../setup_application/database_settings.rst:45
0119 msgid ""
0120 "Take care to use a place hosted by fast hardware (such as SSD or NVMe) with "
0121 "enough free space especially for thumbnails database. A remote file system "
0122 "such as NFS cannot be used here. For performance and technical reasons "
0123 "relevant of SQLite, you cannot use a media from the network."
0124 msgstr ""
0125
0126 #: ../../setup_application/database_settings.rst:47
0127 msgid ""
0128 "SQLite database files could be found in your *collection* folder, which you "
0129 "have added to digiKam. (By default, if you add your “Pictures” collection, "
0130 "the database files will be present in :file:`~/Pictures` folder)."
0131 msgstr ""
0132
0133 #: ../../setup_application/database_settings.rst:53
0134 msgid "The digiKam SQLite Configuration Page"
0135 msgstr ""
0136
0137 #: ../../setup_application/database_settings.rst:57
0138 msgid ""
0139 "The **WAL** SQLite mode is a very important option that we recommend to turn "
0140 "on with large databases to optimize transactions and improve performances."
0141 msgstr ""
0142
0143 #: ../../setup_application/database_settings.rst:60
0144 msgid "The MySQL Database"
0145 msgstr ""
0146
0147 #: ../../setup_application/database_settings.rst:63
0148 msgid "MySQL Versus SQLite"
0149 msgstr ""
0150
0151 #: ../../setup_application/database_settings.rst:65
0152 msgid ""
0153 "`MySQL <https://en.wikipedia.org/wiki/MySQL>`_ is an open-source, relational "
0154 "database management system, written in C and C++. Original development of "
0155 "MySQL by Michael Widenius and David Axmark beginning in 1994. Sun "
0156 "Microsystems acquired MySQL in 2008, which was later acquired by Oracle in "
0157 "2010. MySQL currently works on almost all system platforms (Linux, Microsoft "
0158 "Windows, OS X, SunOS …)."
0159 msgstr ""
0160
0161 #: ../../setup_application/database_settings.rst:67
0162 msgid ""
0163 "`MariaDB <https://en.wikipedia.org/wiki/MariaDB>`_ server is a community "
0164 "developed fork of MySQL server. Started by core members of the original "
0165 "MySQL team, MariaDB actively works with outside developers to deliver the "
0166 "most featureful, stable, and sanely licensed open SQL server in the industry."
0167 msgstr ""
0168
0169 #: ../../setup_application/database_settings.rst:69
0170 msgid "MariaDB has actually overtaken MySQL, because of few basic reasons:"
0171 msgstr ""
0172
0173 #: ../../setup_application/database_settings.rst:71
0174 msgid "MariaDB development is more open and vibrant."
0175 msgstr ""
0176
0177 #: ../../setup_application/database_settings.rst:73
0178 msgid "More cutting edge features."
0179 msgstr ""
0180
0181 #: ../../setup_application/database_settings.rst:75
0182 msgid "More storage engines."
0183 msgstr ""
0184
0185 #: ../../setup_application/database_settings.rst:77
0186 msgid "Better performance."
0187 msgstr ""
0188
0189 #: ../../setup_application/database_settings.rst:79
0190 msgid "Compatible and easy to migrate."
0191 msgstr ""
0192
0193 #: ../../setup_application/database_settings.rst:81
0194 msgid ""
0195 "digiKam also provides support for popular MySQL database engine. Of course, "
0196 "you might wonder why you’d want to switch to MySQL when SQLite already does "
0197 "a good job of managing the data? MySQL offers many advantages for storing "
0198 "digiKam data, especially when collections include **more than 100,000 "
0199 "items**. With such large collections, SQLite introduces latency which slows "
0200 "down the application."
0201 msgstr ""
0202
0203 #: ../../setup_application/database_settings.rst:85
0204 msgid ""
0205 "With **WAL** option enabled, SQLite can be easily used for more than 100,000 "
0206 "items especially with an SSD or NVMe storage. It must be even faster than "
0207 "MySQL and more stable. See `this page <https://www.sqlite.org/wal.html>`_ "
0208 "for technical details."
0209 msgstr ""
0210
0211 #: ../../setup_application/database_settings.rst:87
0212 msgid ""
0213 "Using MySQL as digiKam’s database back-end allows you to store the data on "
0214 "local as well as remote server. Local, to replace the local SQLite storage "
0215 "and latter, to use a shared computer through network. Using MySQL as "
0216 "digiKam’s database back-end allows you to store the data on a remote server. "
0217 "This way, you can use multiple digiKam installations (For instance,on your "
0218 "notebook and PC) to access and manage your photo collections. You can also "
0219 "use MySQL tools to backup and analyze digiKam’s data."
0220 msgstr ""
0221
0222 #: ../../setup_application/database_settings.rst:89
0223 msgid ""
0224 "To switch from SQLite to MySQL database, go to :menuselection:`Settings --> "
0225 "Configure digiKam...` and then under **Database** section, select a database "
0226 "from the drop down list."
0227 msgstr ""
0228
0229 #: ../../setup_application/database_settings.rst:91
0230 msgid ""
0231 "**MySQL Internal**: This allows to run an internal database server on your "
0232 "system. digiKam uses Unix socket for the connection."
0233 msgstr ""
0234
0235 #: ../../setup_application/database_settings.rst:93
0236 msgid ""
0237 "**MySQL Server**: Use this if you’ve your data on remote server and you’re "
0238 "on a different machine trying to access the collection."
0239 msgstr ""
0240
0241 #: ../../setup_application/database_settings.rst:98
0242 msgid "The MySQL Internal Server"
0243 msgstr ""
0244
0245 #: ../../setup_application/database_settings.rst:100
0246 msgid ""
0247 "While using a large collection hosted on hard drive (HDD - not SSD or NVMe "
0248 "device), with a size **greater than 100,000 items**, the application tends "
0249 "to slow down. To avoid the delay and maintain efficiency, digiKam provides "
0250 "option of using **MySQL Internal**. To be clear, this isn’t an actual "
0251 "server, or a public network. Instead, it is a server that runs only while "
0252 "application is running."
0253 msgstr ""
0254
0255 #: ../../setup_application/database_settings.rst:102
0256 msgid ""
0257 "Internal server creates a separate database that can be accessed (only while "
0258 "application is running) using the command:"
0259 msgstr ""
0260
0261 #: ../../setup_application/database_settings.rst:108
0262 msgid ""
0263 "Internal server uses tree MySQL Binary Tools: :file:`mysql_install_db`, :"
0264 "file:`mysqladmin`, and :file:`mysqld`. You can configure their locations in "
0265 "the configuration dialog. digiKam will try to find these binaries "
0266 "automatically if they’re installed on your system."
0267 msgstr ""
0268
0269 #: ../../setup_application/database_settings.rst:114
0270 msgid "The digiKam MySQL Internal Configuration Page"
0271 msgstr ""
0272
0273 #: ../../setup_application/database_settings.rst:119
0274 msgid "The MySQL Remote Server"
0275 msgstr ""
0276
0277 #: ../../setup_application/database_settings.rst:121
0278 msgid ""
0279 "Obviously, to use digiKam with a remote MySQL, you would require a MySQL "
0280 "server. Or, you could also install MariaDB, which serves the purpose well. "
0281 "(Could be installed easily using `this link <https://www.cherryservers.com/"
0282 "blog/how-to-install-and-start-using-mariadb-on-ubuntu-20-04>`_.)"
0283 msgstr ""
0284
0285 #: ../../setup_application/database_settings.rst:123
0286 msgid ""
0287 "Follow the instructions below, if you don’t have a dedicated user account "
0288 "and a digiKam database already set up. Run the commands in MySQL server, "
0289 "after replacing *password* with correct one."
0290 msgstr ""
0291
0292 #: ../../setup_application/database_settings.rst:127
0293 msgid ""
0294 "You can select any database name. (Here it is, *digikam*). Just remember to "
0295 "fill in the database name correctly in Core, Thumbs, Similarity, and Face "
0296 "database names from the dialog box shown below."
0297 msgstr ""
0298
0299 #: ../../setup_application/database_settings.rst:139
0300 msgid ""
0301 "If you have an enormous collection, it's recommended to start the MySQL "
0302 "server with `mysql --max_allowed_packet = 128M`"
0303 msgstr ""
0304
0305 #: ../../setup_application/database_settings.rst:143
0306 msgid ""
0307 "If you have problems with a MySQL server on Ubuntu based Linux system, use "
0308 "the addition command in the mysql prompt to be able to create MySQL triggers."
0309 msgstr ""
0310
0311 #: ../../setup_application/database_settings.rst:149
0312 msgid ""
0313 "Now, in digiKam, go to :menuselection:`Settings --> Configure digiKam...` "
0314 "and then under **Database** section, select MySQL Server from the drop down "
0315 "list."
0316 msgstr ""
0317
0318 #: ../../setup_application/database_settings.rst:155
0319 msgid "The digiKam Remote Mysql Configuration Page"
0320 msgstr ""
0321
0322 #: ../../setup_application/database_settings.rst:157
0323 msgid ""
0324 "Enter the IP address of your MySQL server in the **Host Name** field and "
0325 "specify the correct port in the **Host Port** field (the default port is "
0326 "3306)."
0327 msgstr ""
0328
0329 #: ../../setup_application/database_settings.rst:159
0330 msgid ""
0331 "In the **Core Db Name** field, enter the name of the first database for "
0332 "storing photo metadata."
0333 msgstr ""
0334
0335 #: ../../setup_application/database_settings.rst:161
0336 msgid ""
0337 "Specify the name of the second database for storing wavelets compressed "
0338 "thumbnails in the **Thumbs Db Name** field."
0339 msgstr ""
0340
0341 #: ../../setup_application/database_settings.rst:163
0342 msgid ""
0343 "The third database is dedicated to store the similarity finger-prints "
0344 "performed by the fuzzy search engine. Use the **Similarity Db Name** field "
0345 "for that."
0346 msgstr ""
0347
0348 #: ../../setup_application/database_settings.rst:165
0349 msgid ""
0350 "The last database is dedicated to store face histograms for recognition "
0351 "purpose. Use the **Face Db Name** field for that."
0352 msgstr ""
0353
0354 #: ../../setup_application/database_settings.rst:167
0355 msgid ""
0356 "To be connected safety to the remote server, enter your MySQL identification "
0357 "using **User** and **Password** fields."
0358 msgstr ""
0359
0360 #: ../../setup_application/database_settings.rst:169
0361 msgid ""
0362 "To check whether the database connection works properly, press the **Check "
0363 "Connection** button. If everything works as it’s supposed to, switch to the "
0364 "**Collections** sections, and add the directories containing your photos. "
0365 "Hit **OK**, and wait till digiKam populates the databases with data from "
0366 "photos. This can take a while if you have a lot of items to register in "
0367 "database."
0368 msgstr ""
0369
0370 #: ../../setup_application/database_settings.rst:171
0371 msgid ""
0372 "There are some tips and recommendation to obtain the best results with a "
0373 "remote MySQL database server."
0374 msgstr ""
0375
0376 #: ../../setup_application/database_settings.rst:173
0377 msgid ""
0378 "With slow network, digiKam hangs a lot of time especially when album "
0379 "contains many items **(>1,000)**. This solution relies on network "
0380 "performances. Problem has been reproducible using Wifi connection, for "
0381 "instance. Switching to Ethernet must solves the problem."
0382 msgstr ""
0383
0384 #: ../../setup_application/database_settings.rst:175
0385 msgid ""
0386 "Also, if you have an enormous collection, you should start the MySQL server "
0387 "with `mysql --max_allowed_packet = 128M`. If you’re well acquainted with "
0388 "using MySQL, you could also change your settings in :file:`my.ini` or :file:"
0389 "`~/.my.cnf` files."
0390 msgstr ""
0391
0392 #: ../../setup_application/database_settings.rst:179
0393 msgid ""
0394 "The locale used in the Mysql server must be the same than the locale from "
0395 "the computer used to run digiKam to prevent problem with the double values "
0396 "saved in the tables of the database."
0397 msgstr ""
0398
0399 #: ../../setup_application/database_settings.rst:182
0400 msgid "Database Type Criteria"
0401 msgstr ""
0402
0403 #: ../../setup_application/database_settings.rst:184
0404 msgid ""
0405 "See the resume below to choose the right database type depending of the use-"
0406 "cases."
0407 msgstr ""
0408
0409 #: ../../setup_application/database_settings.rst:187
0410 msgid "Storage"
0411 msgstr ""
0412
0413 #: ../../setup_application/database_settings.rst:187
0414 msgid "Type"
0415 msgstr ""
0416
0417 #: ../../setup_application/database_settings.rst:187
0418 msgid "Items"
0419 msgstr ""
0420
0421 #: ../../setup_application/database_settings.rst:187
0422 msgid "Remarks"
0423 msgstr ""
0424
0425 #: ../../setup_application/database_settings.rst:189
0426 #: ../../setup_application/database_settings.rst:190
0427 #: ../../setup_application/database_settings.rst:203
0428 msgid "HDD"
0429 msgstr ""
0430
0431 #: ../../setup_application/database_settings.rst:189
0432 #: ../../setup_application/database_settings.rst:191
0433 #: ../../setup_application/database_settings.rst:193
0434 #: ../../setup_application/database_settings.rst:195
0435 #: ../../setup_application/database_settings.rst:197
0436 msgid "SQLite"
0437 msgstr ""
0438
0439 #: ../../setup_application/database_settings.rst:189
0440 #: ../../setup_application/database_settings.rst:195
0441 msgid "< 100K"
0442 msgstr ""
0443
0444 #: ../../setup_application/database_settings.rst:189
0445 msgid "**Warning: WAL is mandatory.**"
0446 msgstr ""
0447
0448 #: ../../setup_application/database_settings.rst:190
0449 #: ../../setup_application/database_settings.rst:192
0450 #: ../../setup_application/database_settings.rst:194
0451 #: ../../setup_application/database_settings.rst:196
0452 #: ../../setup_application/database_settings.rst:198
0453 msgid "MySQL-Internal"
0454 msgstr ""
0455
0456 #: ../../setup_application/database_settings.rst:190
0457 #: ../../setup_application/database_settings.rst:196
0458 msgid "> 100K"
0459 msgstr ""
0460
0461 #: ../../setup_application/database_settings.rst:191
0462 #: ../../setup_application/database_settings.rst:192
0463 #: ../../setup_application/database_settings.rst:206
0464 msgid "SSD"
0465 msgstr ""
0466
0467 #: ../../setup_application/database_settings.rst:191
0468 #: ../../setup_application/database_settings.rst:193
0469 msgid "WAL is optional."
0470 msgstr ""
0471
0472 #: ../../setup_application/database_settings.rst:193
0473 #: ../../setup_application/database_settings.rst:194
0474 msgid "NVME"
0475 msgstr ""
0476
0477 #: ../../setup_application/database_settings.rst:195
0478 #: ../../setup_application/database_settings.rst:196
0479 #: ../../setup_application/database_settings.rst:212
0480 msgid "Removable"
0481 msgstr ""
0482
0483 #: ../../setup_application/database_settings.rst:195
0484 msgid "**Warning: WAL is mandatory. USB 3.1 minimum with NVMe drive.**"
0485 msgstr ""
0486
0487 #: ../../setup_application/database_settings.rst:196
0488 msgid "**Warning: USB 3.1 minimum with NVMe drive.**"
0489 msgstr ""
0490
0491 #: ../../setup_application/database_settings.rst:197
0492 #: ../../setup_application/database_settings.rst:198
0493 #: ../../setup_application/database_settings.rst:215
0494 msgid "Network FS"
0495 msgstr ""
0496
0497 #: ../../setup_application/database_settings.rst:197
0498 msgid "**Prohibited: SQLite databases must be stored on local file system.**"
0499 msgstr ""
0500
0501 #: ../../setup_application/database_settings.rst:198
0502 msgid "**Prohibited: MySQL databases must be stored on local file system.**"
0503 msgstr ""
0504
0505 #: ../../setup_application/database_settings.rst:199
0506 #: ../../setup_application/database_settings.rst:218
0507 msgid "Remote"
0508 msgstr ""
0509
0510 #: ../../setup_application/database_settings.rst:199
0511 msgid "MySQL-Server"
0512 msgstr ""
0513
0514 #: ../../setup_application/database_settings.rst:199
0515 msgid "MariaDB server is supported. Gigabit Ethernet or higher is recommended."
0516 msgstr ""
0517
0518 #: ../../setup_application/database_settings.rst:205
0519 msgid "Hard Disk Drive."
0520 msgstr ""
0521
0522 #: ../../setup_application/database_settings.rst:208
0523 msgid "Solid State Drive."
0524 msgstr ""
0525
0526 #: ../../setup_application/database_settings.rst:209
0527 msgid "NVMe"
0528 msgstr ""
0529
0530 #: ../../setup_application/database_settings.rst:211
0531 msgid "Non-Volatile Memory."
0532 msgstr ""
0533
0534 #: ../../setup_application/database_settings.rst:214
0535 msgid "External USB HDD/SSD/NVMe drive."
0536 msgstr ""
0537
0538 #: ../../setup_application/database_settings.rst:217
0539 msgid "Network File System mounted locally."
0540 msgstr ""
0541
0542 #: ../../setup_application/database_settings.rst:220
0543 msgid "Network server as NAS (Network Attached Storage)."
0544 msgstr ""
0545
0546 #: ../../setup_application/database_settings.rst:221
0547 msgid "WAL"
0548 msgstr ""
0549
0550 #: ../../setup_application/database_settings.rst:223
0551 msgid "Write-Ahead Lock (SQLite database only)."
0552 msgstr ""
0553
0554 #: ../../setup_application/database_settings.rst:227
0555 msgid ""
0556 "See this :ref:`Digital Asset Management chapter <storage_deterioration>` for "
0557 "more details about media and data protection."
0558 msgstr ""
0559
0560 #: ../../setup_application/database_settings.rst:229
0561 msgid ""
0562 "See also this :ref:`Collection Settings chapter <collections_settings>` for "
0563 "more details about the way to configure your collections depending of your "
0564 "storage policy."
0565 msgstr ""
0566
0567 #: ../../setup_application/database_settings.rst:233
0568 msgid ""
0569 "If you share the same **Removable** media to host databases and/or "
0570 "collections between different computers, you must have the same kind of "
0571 "operating system, the same mount paths everywhere (use symbolic links to "
0572 "revolve paths), and the same digiKam version everywhere to prevent conflicts "
0573 "with database schemes."
0574 msgstr ""
0575
0576 #: ../../setup_application/database_settings.rst:235
0577 msgid ""
0578 "If you use a common **Remote** server to host databases and collections, you "
0579 "must use the same digiKam version everywhere to prevent conflicts with "
0580 "database schemes. Computers running digiKam cannot be used at the same time "
0581 "on collections."
0582 msgstr ""
0583
0584 #: ../../setup_application/database_settings.rst:237
0585 msgid ""
0586 "If you use a common **Remote** server to host collections, as databases are "
0587 "located on computers, different versions of digiKam can be used and digiKam "
0588 "sessions can run at the same time on collections. Take a care about "
0589 "concurrency access on files metadata if you turned on this option on "
0590 "**Metadata Setup Page**."
0591 msgstr ""
0592
0593 #: ../../setup_application/database_settings.rst:242
0594 msgid "Database Migration"
0595 msgstr ""
0596
0597 #: ../../setup_application/database_settings.rst:244
0598 msgid ""
0599 "The photo management application comes up with an exclusive tool named "
0600 "**Database Migration**, that allows users to migrate their data. Suppose, "
0601 "you’re using SQLite and you wish to move all data to MySQL database, "
0602 "migration tool will help you do so. It can help you migrate data from SQLite "
0603 "to MySQL and vice versa."
0604 msgstr ""
0605
0606 #: ../../setup_application/database_settings.rst:246
0607 msgid ""
0608 "To migrate to another database, go to :menuselection:`Settings --> Database "
0609 "Migration...`. A dialog box appears:"
0610 msgstr ""
0611
0612 #: ../../setup_application/database_settings.rst:252
0613 msgid "The digiKam Database Migration Tool"
0614 msgstr ""
0615
0616 #: ../../setup_application/database_settings.rst:254
0617 msgid ""
0618 "Now choose appropriate database types you want to convert to. Finally, click "
0619 "on **Migrate** button to convert the database from SQLite to MySQL (or vice "
0620 "versa). Depending of the database size this operation can take a while."
0621 msgstr ""
0622
0623 #: ../../setup_application/database_settings.rst:258
0624 msgid ""
0625 "Only the digiKam **Core** database will be migrated while conversion "
0626 "process. All other databases needs to be rebuilt as post-processing with "
0627 "the :ref:`Maintenance Tools <maintenance_tools>`. The **Thumbs** and "
0628 "**Similarity** databases needs to be created from scratch, and the **Face** "
0629 "database needs the option **Rebuild the Training Data**."
0630 msgstr ""
0631
0632 #: ../../setup_application/database_settings.rst:263
0633 msgid "Database Backup Recommendation"
0634 msgstr ""
0635
0636 #: ../../setup_application/database_settings.rst:265
0637 msgid ""
0638 "For security reasons, planing a database backup using crontab over the "
0639 "network can help against device dysfunctions. A NAS or an external drive can "
0640 "also be used for that."
0641 msgstr ""
0642
0643 #: ../../setup_application/database_settings.rst:267
0644 msgid ""
0645 "Each database can be named with a different name, not only *digikam*. This "
0646 "allows to users to backup only what is needed. For instance, naming **Core** "
0647 "database as *digiKam_Core*, allows to isolate only this table (the most "
0648 "important file). **Thumbnails**, **Similarity** and **Face Recognition** "
0649 "databases can always be regenerated for scratch."
0650 msgstr ""
0651
0652 #: ../../setup_application/database_settings.rst:269
0653 msgid ""
0654 "The chapter about digiKam :ref:`Maintenance Tools <maintenance_tools>` will "
0655 "explain how to maintain in time the database contents and how to synchronize "
0656 "the collections with databases information (and vice versa)."
0657 msgstr ""
0658
0659 #: ../../setup_application/database_settings.rst:274
0660 msgid "Database Statistics"
0661 msgstr ""
0662
0663 #: ../../setup_application/database_settings.rst:276
0664 msgid ""
0665 "digiKam provides a unique tool to show the statistics from your collections. "
0666 "It includes count of images, videos (including individual count by image "
0667 "format), tags etc. Also, includes the **Database Backend** (QSQLITE or "
0668 "QMYSQL) and the **Database Path** (where your collection is located)."
0669 msgstr ""
0670
0671 #: ../../setup_application/database_settings.rst:278
0672 msgid ""
0673 "You can view your statistics by going to :menuselection:`Help --> Database "
0674 "Statistics...`. A dialog box like this will appear:"
0675 msgstr ""
0676
0677 #: ../../setup_application/database_settings.rst:284
0678 msgid "The digiKam Database Statistics Dialog"
0679 msgstr ""