Using Mysql with Subsonic 6.1

[texxasrulez]

EDIT: I found this page http://www.subsonic.org/pages/database.jsp detailing the external DB setup ...

I searched forums to use mysql and found nothing, so I am posting what I have done on Debian to use a mysql database.

edit /etc/default/subsonic and add --db=JDBC:mysql://localhost:3306/DATABASE?user=DATABASE_USER&password=PASSWORD to SUBSONIC_ARGS= section of file and restart Subsonic (service subsonic restart) and db schema will be created and you should be good to go ...

Have a good day ...

[acroyear]

Does it migrate an existing (6.0 and earlier) DB or is it creating things from scratch?

[texxasrulez]

Unfortunately it did not migrate everything. I had to manually add users back and starred music. I had to add media folder and rescan it. This process was slower with mysql I noticed than using the default db.

I tried to search for a migration tutorial but I didn't find anything. They way I look at it, this was the last time I had to do it as mysql is backed up more reliable than the internal db from subsonic.

[acroyear]

I'm more concerned because my playlist randomizer/generator (SubFire Radio) works by storing the IDs, not the names, of things like other playlists, songs, albums, etc. On a rescan, those IDs will likely change, invaliding the generators. I have an 'export' function that will log the asset ID to its name in order to help reconstruct, but I never finished the re-importer.

[medilane1]

Hello,
Thank you very much for the info but I can not: /
Where to configure the
edit /etc/default/subsonic and add --db=JDBC:mysql://localhost:3306/DATABASE?user=DATABASE_USER&password=PASSWORD to SUBSONIC_ARGS=

I looking on the site http://www.subsonic.org/pages/database.jsp
But it's the same not understand or modify the jdbc..

Thank You for your help