The plugin uses 2 databases. One .mmdb file database to detect user IP and convert it to locations and one mysql database with all the cities of the world for configuration purposes. On some occasions you will need to populate database manually.
CSV cities database
If you are not seeing cities on the dropdown after choosing a country it’s possible that your database was not populated correctly. This is usually to hostings like WpEngine deactivating mysql command “LOAD DATA IN FILE” . You can try the following:
1- Visit your site admin area and append the following to the url wp-admin/admin.php?page=geot-settings&geot_db_update=true . EG: www.domain.com/wp-admin/admin.php?page=geot-settings&geot_db_update=true . This will run the automatic download proccess
2- Manually upload cities into the databse: For this you need to have access to phpmyadmin or similar tool. First select your wordpress database and then select the geo_cities table and after that choose Import. You can download the .csv files from here and Import one by one. Check the image below for reference on how to import them , be sure you copy the exact column names):
Populating mmdb file
The GeoLite2-City.mmdb is Maxmind database file that needs to located on wp-content/uploads/geot_plugin/mmdb/ folder. If you don’t see the file there you have two options:
1- Visit your site admin area and append the following to the url wp-admin/admin.php?page=geot-settings&geot_db_update=true . EG: www.domain.com/wp-admin/admin.php?page=geot-settings&geot_db_update=true . This will run the automatic download proccess
2- Manually upload the database to that folder. You can grab latest version from here. Simple upload and then unzip the file on destination.
Clearing update message
Once you manually updated the database you will need to clear the update message that appears on top of your screen. To do that simple visit the following url: wp-admin/admin.php?page=geot-settings&geot_db_update_finish=true
Upcoming changes
We are working on a new API that will serve ip to location services right on our servers. That means you won’t have to download or update any database never again. We will handle that on our side and will server premium geolocation results. Stay tuned for news!