sqlite database dumps mm->mysql

gus24 · 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.

Teknojnky · Post by **Teknojnky** » Thu Dec 10, 2009 4:49 pm

see @ http://www.mediamonkey.com/wiki/index.p ... _structure

gus24 · 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 · 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.

sqlite database dumps mm->mysql

sqlite database dumps mm->mysql

Re: sqlite database dumps mm->mysql

Re: sqlite database dumps mm->mysql

Re: sqlite database dumps mm->mysql