https://wiki.creativecommons.org/index.php?action=history&feed=atom&title=Syncing_Magnatune_DBSyncing Magnatune DB - Revision history2026-05-10T01:10:25ZRevision history for this page on the wikiMediaWiki 1.30.0https://wiki.creativecommons.org/index.php?title=Syncing_Magnatune_DB&diff=1443&oldid=prevMike Linksvayer at 19:43, 5 January 20062006-01-05T19:43:14Z<p></p>
<p><b>New page</b></p><div>== NEW STEPS TO UPDATING OUR MAGNATUNE SONG DB ==<br />
<br />
1. Download song_info.sql from http://magantune.com/info<br />
<br />
2. Remove all lines with 'PREVIEW' in them (these are dupes)<br />
<br />
3. Search/replace 'magnatune_song_info' with 'new_magnatune_song_info'<br />
<br />
4. mysql -u mixter -p mixter < song_info.sql<br />
<br />
5. Browse to: http://ccmixter.org/magnatune/mt/syncpool (takes about a minute or two)<br />
<br />
6. Browse to http://ccmixter.org/media/mixter/eval then load and run the scriptlet called 'drop_magnatune_new_song_db'<br />
<br />
<br />
=== NOTES === <br />
<br />
* the new sync function is in mixter-files/mixter-magnatune.php<br />
* I also added a field to cc_tbl_pool_item called 'albumsku'<br />
<br />
[[Category:CcMixter]]</div>Mike Linksvayer