Syncing Magnatune DB

From Creative Commons
Revision as of 19:43, 5 January 2006 by Mike Linksvayer (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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'