Where to find MySQL DB for Country, State & City Tables

Hello,

I hope this is the right forum to post this question.
I could not see where would be better suited than here so I am posting here.

So what I am looking for is a MySQL DB, preferably free but can pay for it, that has 3 Tables:
1- All countries of the World
at least should have: ID, Country name

2- All States/Provinces of each Country, of course not all countries have states.
at least should have: ID, country_id, state_name

2- Cities of each State, can be the Top 50 or 10 cities of each state
at least should have: ID, state_id, city_name

Regards,

I think your best bet for this is:

http://www.geonames.org

ThanX. But this does not give me what I need which is Country then States of that Country and then Cities of that State in a MySQL DB.

I got all the provinces and all the corresponding municipalities of Spain from it.

Have a look here it tells you how to get them.

http://www.geonames.org/export/place-hierarchy.html

Hi,

I checked the URL below, but do not see where there is a Download of what I am looking for! Did I somehow miss it? If so please point me to it. ThanX.