Slimserver uses MySQL as the database backend. Extracting data from the db involves some work. This is what has worked for me, extracting the data to a windows MS Access database:
Get MySQL Administrator and the windows ODBC driver (free downloads) from the MySQL website. Install both. If you aren't using a separate instance of MySQL on your Slimserver machine (you probably aren't) then you need point MySQL administrator at port 9092 and log in with the username, password slimserver, slimserver. Once you've connected to the MySQL db, you'll need to change the data types of any field in the ALBUMS, CONTRIBUTORS, GENRES and TRACKS tables that are defined as a BLOB datatype to the TEXT datatype. Once you've done that, you can create a "DSN" with the ODBC driver, again making sure that you're pointing to port 9092 and using "slimserver" for the username and password. Once that is done, you can use MS Access, create a database and then link to the tables in the MySQL db via the ODBC DSN. And once that is done, you can use the Access database like any other Access database: create relationships between tables, create complex queries, create reports, change data, etc. The whole key here, though, is that you have to change those BLOB data types in fields in the GENRE, TRACK, etc. tables to TEXT. Last time I tried this, the ODBC driver still couldn't handle the BLOB datatype. I think that as long as you aren't using double-type metadata in your music library (e.g. Chinese idograms, etc.) Slimserver won't object to the change in the datatype in the tables. Sorry I can't give you a more explicit recipe here. Getting this to work took lots of trial and error. Good luck. -- gharris999 ------------------------------------------------------------------------ gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115 View this thread: http://forums.slimdevices.com/showthread.php?t=38234 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/ripping
