migrating podcasts sqlite -> mysql

[Art Alexion]

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

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


-- 

_____________________________________________________________
Art Alexion

PGP fingerprint: 52A4 B10C AA73 096F A661  92D2 3B65 8EAC ACC5 BA7A
Keyserver: hkp://subkeys.pgp.net
The attachment - signature.asc - is my electronic signature; no need for 
alarm.  Info @ 
http://mysite.verizon.net/art.alexion/encryption/signature.asc.what.html
_____________________________________________________________
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 309 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20061205/d6e069c8/attachment.sig>