class=”article first_main_article” readability=”76″>
As I proposed the other day following the release of Amarok 2.4, over two articles we will take full advantage of this incredible media player. We started with MySQL.
Amarok, besides being a music player loaded with features, is primarily a manager for audio collections, for which comes by default with a small database called SQLite. If our musical repertoire is large, if it exceeds the 3000 or so tracks, we will have problems , and general slowness (in content indexing, search, etc) or empty albums (disks added but does not include topics), to name two of the most common. If our musical repertoire is small, with SQLite VAMOS, although performance is still lower, slow down, literally, that if we use custom options. In short, from lowest to highest, MySQL can speed things up or be directly imperative .
The first step to allow Amarok to 100% is to install and configure MySQL … and here comes one problem: although the way is almost common, depending on the distribution requires a MySQL or other units, or have to install a part-or configured in one way or another (some distros have visual aids, everything is in other console …). As you understand, in these circumstances it’s difficult to explain only to the major distros, it would take too long and even an article would be confusing with so much information, which is why I always refer to the valuable documentation that is available for example, for Arch Linux, Debian, Mandriva, openSUSE and Ubuntu / Kubuntu (and other family as well as Linux Mint or any other distro based on Ubuntu).
must bear in mind that MySQL is a database that is used for many things, in this case not need you to go beyond making the administrator account and enable the daemon to start with system . So the first points of the wikis linked should be sufficient (eye with the root password, which we will need each time you want to make any changes to the database).
MySQL up and running, it will first be create a new user to be responsible for the Amarok audio library (could use the default user, but if in the future should do more use of the database and everything is cleaner.) Open the console and type:
Enter the password and see how he is “ mysql> ” as a new shell, which means that we have successfully identified. We then create the new user:
amarokuser and password amarokpass . I do this for simplicity, but you can change it as you wish.
Without closing the console, open Amarok and go to “ Settings> Configure Amarok> Database .” Check “Use external MySQL database ” and change the username and password as appropriate. Before applying the changes, if we look beneath the data fields it has to be concluded Amarok tells us how this task:
Copy in a text editor the Amarok statements provided to us in the box below and again change the username and password as appropriate. Now, apply the changes and close the configuration (go, we ran out of music collection:) It only remains for us what we paste the text editor in the MySQL console and restart Amarok .
V Oila , everything is done. From now MySQL will handle the Amarok database.
we are here. Sorry I could not better explain the first part and let you read external documentation, but sometimes have no choice (and thus learn;). On Friday we continued and finished as it deserves to leave Amarok to 100%.