Syncing Magnatune DB

NEW STEPS TO UPDATING OUR MAGNATUNE SONG DB

1. Download song_info.sql from http://magantune.com/info

2. Remove all lines with 'PREVIEW' in them (these are dupes)

3. Search/replace 'magnatune_song_info' with 'new_magnatune_song_info'

4. mysql -u mixter -p mixter < song_info.sql

5. Browse to: http://ccmixter.org/magnatune/mt/syncpool (takes about a minute or two)

6. Browse to http://ccmixter.org/media/mixter/eval then load and run the scriptlet called 'drop_magnatune_new_song_db'

NOTES

• the new sync function is in mixter-files/mixter-magnatune.php
• I also added a field to cc_tbl_pool_item called 'albumsku'