This scripts downloads the below files to the download folder:-  1.http://download.geonames.org/export/dump/allCountries.zip  2.http://download.geonames.org/export/dump/alternateNames.zip  3.http://download.geonames.org/export/dump/admin1CodesASCII.txt  4.http://download.geonames.org/export/dump/timeZones.txt  5.http://download.geonames.org/export/dump/featureCodes_en.txt  6.http://download.geonames.org/export/dump/iso-languagecodes.txt  7.http://download.geonames.org/export/dump/countryInfo.txt  After downloading the files the 2 zipped files are allCountries.zip and alternateNames.zip are UNZIPPED by the script  Then correspoding database tables are created for the above downloaded files to import Filename => database tables name 1.allCountries.txt ==> geo_name 2.alternateNames.txt ==> geo_alternateNames 3.admin1CodesASCII.txt ==> geo_admin1 4.timeZones.txt ==> geo_timeZones 5.featureCodes_en.txt ==> geo_featureCodes 6.iso-languagecodes.txt ==> geo_languagecodes 7.countryInfo.txt ==> geo_country  Then the all the information are imported to their corresponding table