migrating podcasts sqlite -> mysql

[Rich]

Art Alexion wrote:
> On Monday 04 December 2006 22:57, Nick Tryon wrote:
>> On 12/4/06, Jeff Mitchell <kde-dev at emailgoeshere.com> wrote:
>>> 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.
>> http://amarok.kde.org/wiki/MySQL_HowTo#Database_Conversions
> 
> unfortunately did not work for me.  First line
> 
> sqlite3 collection.db .dump 
> 
> produces only
> 
> BEGIN TRANSACTION;
> COMMIT;
> 
> even though 'ls -l collection.db' indicates 
> 
> -rw-r--r-- 1 arthur users 9518080 2006-12-02 12:54 collection.db

check that your version of local sqlite binaries match with sqlite 
version used in amarok

> and I can see that there is data in it with 'cat collection.db'
...
-- 
  Rich