Slimserver - Public Content

All this if for Slimserver running on Ubuntu

Connecting to your slimserver's database

su to slimserver

mysql -S /var/cache/slimserver/slimserver-mysql.sock

Finding duplicate mp3's

create temporary table dups as select title from tracks group by title having count(*) > 1;

 select t.id, a.title, t.title, t.url from tracks t, albums a, dups d where t.title = d.title and a.id = t.album order by t.title;