migrating podcasts sqlite -> mysql

[Andrew Turner]

The SQLite website has static binaries available, eg:
http://www.sqlite.org/sqlite3-3.3.8.bin.gz

I believe 3.3.8 should be able to read a 3.3.6 DB.

Andrew

On 06/12/06, Art Alexion <art.alexion at gmail.com> wrote:
> If there is anyone with SQLite 3.3.6 installed, and willing to run a dump of
> my collection.db to a file and email it back to me, I would be most
> appreciative.  Please contact me off list if you can do this for me.
>
> Thanks.
>
> On Wednesday 06 December 2006 09:28, Art Alexion wrote:
> > Ahhhhh...... I have 3.2.8.
> >
> > On Tuesday 05 December 2006 22:48, Jeff Mitchell wrote:
> > > sqlite3.h says:
> > >
> > > #define SQLITE_VERSION         "3.3.6"
> > >
> > > --Jeff
> > >
> > > On Tuesday 05 December 2006 10:27, Art Alexion wrote:
> > > > On Tuesday 05 December 2006 11:36, Rich wrote:
> > > > > 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
> > > >
> > > > What is the version used in amarok 1.4.4?
>
> --
>
> _____________________________________________________________
> 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
> _____________________________________________________________
>
>
> _______________________________________________
> Amarok mailing list
> Amarok at kde.org
> https://mail.kde.org/mailman/listinfo/amarok
>
>
>
>