Hi, I would like to fetch all page text information of all wiki pages that belong to a movie category. Eg: http://en.wikipedia.org/wiki/Category:Hindi_songs From the page text I would like to extract information related to song title, song length, singer, name of movie/album etc. I am not interested in extracting images just the information about the song. My questions: 1) Is there a way to download only those pages that I am interested in that belong to a particular category instead of downloading the entire dump? 2) Is it required to have PHP knowledge to install the db dump on a local machine? 3) Are there are tools that extract the information and provide the required data to be stored in MySQL database? If this is not the right forum to have my questions answered could you please redirect me to the appropriate forum. Thanks and regards, Venkatesh Channal _______________________________________________ Xmldatadumps-l mailing list Xmldatadumps-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l

You should probably take a look at DBpedia. Go to http://dbpedia.org/sparql and try this query: select distinct * where { ?song <http://purl.org/dc/terms/subject> < http://dbpedia.org/resource/Category:Hindi_songs> . ?song rdf:type <http://dbpedia.org/ontology/Song> . ?song <http://dbpedia.org/ontology/artist> ?artist . ?song <http://dbpedia.org/ontology/runtime> ?runtime . } limit 100 If that's interesting for you there is more info at: http://dbpedia.org/ In that case, the right list would be: https://lists.sourceforge.net/lists/listinfo/dbpedia-users Cheers, Pablo On Mon, Oct 8, 2012 at 4:45 PM, Venkatesh Channal < venkateshchannal(a)gmail.com&gt; wrote: -- --- Pablo N. Mendes http://pablomendes.com Events: http://wole2012.eurecom.fr