migrating podcasts sqlite -> mysql

[Jeff Mitchell]

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?