gharris999;225842 Wrote: > 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.
Hi, I managed to retrieve data from MySQL in MS-Access, but I can't get the artwork to load in reports. Is there any way to do that? I have tried to insert an image and to set the property "picture" to "http://127.0.0.1:9000/music....."; but it says that it's not supported... Any other idea? Thanks -- elite1967 ------------------------------------------------------------------------ elite1967's Profile: http://forums.slimdevices.com/member.php?userid=15576 View this thread: http://forums.slimdevices.com/showthread.php?t=38234 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/ripping
