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'