it's a bit late for me to answer this one but i still want to answer.
Guys I am on a shared hosting ain't have full access to all SQL features.
I assume you can access the database where you can at least create/edit table.
I am only interested in 2 files ES, AR. I only want the cities and county names nothing else.
Upload them all.
Then go to STRUCTURE, delete the unnecessary column, don't delete the primary index ID column because it is better to have an index.
P.S is there a way to let say retrieve this data.
City or town -> it's province or state it belong to?
Code:
SELECT * FROM table WHERE city='cityName'
or
SELECT * FROM table WHERE state='stateName'