💾 Archived View for chirale.org › 2008-01-22_87c82aaf28ec7e2ed89f86832c1993fb.gmi captured on 2024-08-18 at 17:33:51. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2024-05-12)

-=-=-=-=-=-=-

Optimize Amarok collection indexing using MySQL

By default, Amarok use SQLite to store collection informations. If you’ve a running MySQL or Postgre server on your machine, you can optimize Amarok collection indexing reducing retrieval time.

Amarok MySQL configuration

SQLite

=> https://chirale.wordpress.com/wp-content/uploads/2008/01/amarok_config.thumbnail.jpg Amarok MySQL configuration

Open a root shell (sudo bash) and run mysql

     mysql> create database amarok; Query OK, 1 row affected (00 sec) mysql> grant all privileges on amarok.* to 'amarok'@'localhost'\ identified by 'type_here_your_password'; Query OK, 0 rows affected (00 sec)

Open Amarok and go to Settings \> Amarok configuration \> Collection and fill the database fields (watch screenshow)

If you got an error don’t worry, simply force collection re-scan (Tools)

Now your music collection run on an efficient MySQL database.

https://web.archive.org/web/20080122000000*/http://en.wikipedia.org/wiki/SQLite