World City Names Database

World City Names Database is a complete database that includes world city names with latitude and longitude for all the cities and places of each of the continents every country and region. This enormous collection has some 2.79 million cities and places of the planet Earth.
The package contains readily executable SQL dump files to create and populate the world city database. Any other data format is available on request. The database has cities and places of 246 countries and 4500+ regions comprising a total of 2.79+ millions of entries.
The list is the largest and unique collection of its kind on the web. The data is ready to be published on your content web site or application. The dump files are splitted to manageable units. The file "world-city-database-regions.sql" should be run first in order to create the tables and all entries but the cities. All other scripts will create the entries in CITIES table and can be run in any sequence.
Data Format: The package contains data as SQL dump files. SQL Dump files are script files that can be readily executed from a SQL query tool such as MySQL query browser. The script will create required tables and populate with the data.