##Shell Script for importing geonames.org data dumps into a MySQL database. The contents of this project are a compendium of different knowledge adquired about GeoNames geographical database. Most of this knowledge was obtained from the GeoNames Forum - Importing all geonames tables to MySQL. The result is a linux shell script that allows you to download the GeoNames dumps from the official site and create a MySQL database structure in which you can import that dumps.

The script has two different operation modes.

###Downloading last geonames.org dumps In order to get the latest dumps from geonames.org you can invoke the script in this way.

geonames_importer.sh -a download-data

The result files should be:

• admin1CodesASCII.txt
• allCountries.txt
• alternateNames.txt
• countryInfo.txt
• featureCodes_en.txt
• iso-languagecodes.txt
• timeZones.txt

Plus "continentCodes.txt". This file is not included as a downlodable file by geonames.org and is provided as part of this git repository.

###Creating and dealing with the geographic database There are some individual operations that you could use. In all of them you have to provide a user name and a password to access your database server. Optionally you can specify the host, port number of your MySQL server and a dabatase name in which to insert the data from geonames.org. If you don't provide this optional values the parameters will take the following deafult values:

• Data Base Host => localhost
• Data Base Port => 3306
• Data Base Name => geonames

1.- Create a new database struct.

geonames_importer.sh -a create-db -u <user> -p <password> [-h <host>] [-P <port>] [-n <dbname>]

2.- Import the dumps obtained in the previous operation mode into the database.

geonames_importer.sh -a import-dumps -u <user> -p <password> [-h <host>] [-P <port>] [-n <dbname>]

3.- Dropping the geographic database (you will lose struct and data, so type with care!!!).

geonames_importer.sh -a drop-db -u <user> -p <password> [-h <host>] [-P <port>] [-n <dbname>]

4.- Truncates geographic data from the database. This will delete all the data contained in the database but will keep the whole struct.

geonames_importer.sh -a truncate-db -u <user> -p <password> [-h <host>] [-P <port>] [-n <dbname>]