LC_MESSAGES/setup_application/database_settings.po

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