I built a new computer and I am upgrading Slackware versions (including going from 32-bit to 64 bit) and needed a way to bring over my Amarok podcast URLs to the new machine. I am running 1.4.10 (KDE 3.5.10) on my old system.

I searched the web looking for the answer on how to get the urls. I figured that I would just past the urls into the new Amarok under the new installation.

Here is what I did to get the URLs out of Amarok.

This version of Amarok stores its data in a sqlite database named 'collections.db' found in ~/.kde/share/apps/amarok/
[note that '~' means your home directory].

I found that I had sqlite3 installed on my Slackware 12.x installation. I searched for the commands to extract the data from the database. I made a copy of the collections.db file so that I didn't run the risk of breaking anything.

I then queried the database to find out which tables were available:
$ sqlite3 collection.db ".table"
admin directories playlists tags
album embed podcastchannels tags_labels
amazon genre podcastepisodes uniqueid
artist images podcastfolders year
composer labels related_artists
devices lyrics statistics

I then queried the podcastchannels table to see what columns it had:
$ sqlite3 collection.db ".schema podcastchannels";

CREATE TABLE podcastchannels (url VARCHAR(1024) UNIQUE,title VARCHAR(255),weblink VARCHAR(1024),image VARCHAR(1024),comment TEXT,copyright VARCHAR(255),parent INTEGER,directory VARCHAR(255),autoscan BOOL, fetchtype INTEGER, autotransfer BOOL, haspurge BOOL, purgecount INTEGER );
CREATE INDEX url_podchannel ON podcastchannels( url );

I then queried for the podcast title and URL:

$ sqlite3 collection.db "select title, url from podcastchannels";

The lottalinuxlinks linux podcast ogg feed|http://lottalinuxlinks.com/podcast/ogg.xml
Nikonians Podcasts :: For the ambitious photographer and imaging professional.|http://podcasts.nikonians.org/index.xml
Slashdot Review - Produced by SDR News|http://slashdotreview.com/wp-rss2.php
...

Note that the fields are pipe-delimited ('|').

Then I queried just for the just the URL:
$ sqlite3 collection.db "select url from podcastchannels";

http://lottalinuxlinks.com/podcast/ogg.xml
http://podcasts.nikonians.org/index.xml
http://slashdotreview.com/wp-rss2.php
...

That was all I needed.

I will keep a copy of this database just in case I need anything else.

It took me a bit of searching around to figuring out how to do this, so I wanted to post this message to save someone else the headache.

BTW: this is my first post to LQ.

- LinuxD

Thanks for sharing, and welcome to LQ forums.

that worked perfectly, thanks!