In case I ever forget this again, I’m posting these instructions here. It’s actually really easy.
- Install OpenSSH from Cydia
- Mount the iPod’s filesystem: mkdir -p ~/touch && sshfs -o allow_other root@192.168.1.7:/ ~/touch/
- Then, in Amarok 2, go to the collection browser, and find all the songs that match your criteria (I use ratings):
- Highlight them and right-click drag them into the Dolphin/Nautilus window showing the directory ~
/touch/private/var/mobile/Media/Music/
- You may have to create the above directory.
- When you drop them, choose Copy. Then, wait, and they’ll all copy over the wireless to the device. It’s awesome.
- Get PwnPlayer from Cydia and enjoy!
Uncategorized
amarok, awesome, files, fuse, ipod, ipod touch, jailbreak, mp3, music, sshfs
I was having a bunch of trouble today importing my old MySQL amarok database into the new nightly version of amarok I installed. The Amarok Wiki had a great section on how to convert a MySQL Amarok collection into an SQLlite one. This was the key to importing my old 1.4 collection into the new 2.2 nightly version of Amarok.
Uncategorized
amarok, data, database, import, linux, music, processing, ubuntu
I was messing around writing some sweet SQL statements for amarok tonight. You can either run them using the MySQL console or using dcop (google ‘amarok dcop’). Here’s some examples:
# List artists and their average rating and number of ratings ordered by favorite artists first
SELECT a.name, avg(s.rating) avg, COUNT(s.rating) count FROM tags t, artist a, statistics s WHERE a.id=t.artist AND t.url=s.url GROUP BY a.name HAVING count > 10 ORDER BY avg DESC;
Uncategorized
amarok, linux, music, mysql, sql
