http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net http://forum.geonames.org/gforum/posts/list/732.page and just modify the LOAD DATA INFILE statements to include only the columns we need into our Country table. Then load the full alternateNames file into the table and later delete the rows which doesn't have a corresponding geonamesid in the Country table. Is there any plans from the geonames crew to dump a file with alternate names only for countries? Or is there a way to strip out all the entries from alternateNames.txt that don't belong to a country? We can of course easily create a small program to parse the files exactly as we want, but that might be a waste of time.]]> http://forum.geonames.org/gforum/posts/list/2634.page#9530 http://forum.geonames.org/gforum/posts/list/2634.page#9530 GMT http://forum.geonames.org/gforum/posts/list/2634.page#9533 http://forum.geonames.org/gforum/posts/list/2634.page#9533 GMT