How to extract all titles of biography and geography articles from english Wikipedia

There are more than 1.8 million biography articles and 1.2 million geography articles in english Wikipedia. Here we need to extract all the titles of these articles from Wikipedia’s data files. Get the dump file of Wikipedia from the database download page. (file size ~ 20GB) Get database dump file of category links whose name …