How the f do I parse these huge Dumps from DMOZ.org/rdf? I would maybe be able to make something if I could even see the inners of the file but my comp freezes when I try to open them. I want to extract the information and directly put it into a MySQL tabe:
CREATE TABLE dbsearch (
Title varchar(255) default NULL,
URL varchar(255) default NULL,
Description varchar(255) default NULL,
Category varchar(255) default NULL, //IF POSSIBLE
E_Mail varchar(255) default NULL, //NOT NECESSARY
Status varchar(255) default NULL //NOT NECESSARY
)
LOL... If it isnt true XML then I am lost... Plz help.