Using Serviio with MySQL
I'm using MySQL because my database 'll become very large, and the DNS 320L has only 256 MB ram, and I put my database on a AWS server that I own, so I don't need to bother with the memory usage of the database, and I can use general admin tools to tweak the data / database.
That was my need, you can use mysql for any reason you want.
Quick step-by-step for installing, after a clean install of serviio 1.4 (data migration is on your own ):
1. Stop Serviio
2. Go to lib folder (/usr/share/serviio/lib on my box) and put mysql-connector-java-X.Y.Z-bin.jar (I downloaded from http://dev.mysql.com/get/Downloads/Conn ... .28.tar.gz)
3. Open serviio.jar on the same folder with winrar (.jar is a zip)
4. Extract serviio.properties to somewhere and edit it
4.1. Change db_schema_url property to jdbc:mysql://<your mysql host>/<your database>?user=<your username>&password=<your password> (Reference syntax of the url at http://dev.mysql.com/doc/refman/5.0/en/ ... rties.html)
5. Put serviio.properties back to the .jar
6. Put my modified scripts on the sql folder of the .jar (overwrite all. If you want to use a prior version of Serviio, put only the relevant .sql files for your version)
7. Close winrar, start Serviio
I Hope it can help anyone.
(Edit: not fully funcional. Serviio rely on derby syntax, mainly FETCH FIRST 1 ROWS ONLY. Can the developers put it on the .properties file?)