migrating podcasts sqlite -> mysql

[Jeff Mitchell]

Art--

You could probably do a dump of the sqlite database (I'm not sure how one does 
it in sqlite; it'd be the equivalent of a mysqldump command).  Then you can 
search through the text for the filename that you have, and the associated 
information.

Hope this helps,
Jeff

On Monday 04 December 2006 08:52, Art Alexion wrote:
> I recently switched from using sqlite to mysql.  I did not attempt a
> conversion, but just let amarok recreate the collection.  I don't care
> about playcounts, etc.
>
> One thing I do miss are the podcasts.  I can easily resubscribe, but my
> problem is matching already downloaded podcasts to the manager.  Most
> podcast files that I have are named things like
> npr096g-rfa5-098765432-abcvd.mp3 and I have no idea which podcast to match
> it to.
>
> Is there a way to read the sqlite database and thereby match the names of
> the podcasts to the names of the files?