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