The genre table doesn't follow the id3 convention
(http://www.id3.org/id3v2.4.0-frames.txt) for genre
I'm attaching the genre table, as copied from the spec
(above). Here is how to import it into your database
from the MySQL shell:
mysql> LOAD DATA INFILE '/path/to/id3genre.txt'
-> INTO TABLE genre
-> FIELDS TERMINATED BY '.';
WinAmp has also appended their own tags to this list
which I'm also attaching here. Import those in exactly
the same way as above.
If desired (after importing both tables), delete tags
that are not in either of these lists by using the
following command in the mysql shell:
mysql> delete from genre where id>125;
Log in to post a comment.