sqlite database dumps mm->mysql

This forum is for questions / discussions regarding development of addons / tweaks for MediaMonkey.

Moderator: Gurus

gus24

sqlite database dumps mm->mysql

Post by gus24 » Thu Dec 10, 2009 3:51 pm

Hi,

I'm trying to do some offline analysis of my mediamonkey database, and was wondering if anyone has found an easy way to automate dumping the SQLite data (specificly artists, songs and albums tables) so that I can then import them into mysql..


any suggestions would be greatly appreciated.


gus24

Re: sqlite database dumps mm->mysql

Post by gus24 » Thu Dec 10, 2009 6:40 pm

I am having difficulty getting that far with all my sqlite tools because of the additions to MM3, and the collation

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Re: sqlite database dumps mm->mysql

Post by Teknojnky » Thu Dec 10, 2009 6:41 pm

yup, not sure your gonna get much luck

you might try bex's sql viewer script, it allows you to view and interact with the database from directly within MM using the SQLite engine inside MM.

Post Reply