Location / IP Geo plugin restrict to one country

Hi,

My website only targets the United Kingdom. How do I install only the locations / IP Geo database for just the UK?

The default database table : fl_ipgeo has over 9 million entries which takes a lot of server resources when searching by location.

Many thanks

Need to run 2 mysql queries in turn:

DELETE `T1` FROM `fl_ipgeo` AS `T1` LEFT JOIN `fl_ipgeo_locations` AS `T2` ON `T1`.`Loc_ID` = `T2`.`Loc_ID` WHERE `T2`.`Country_code` <> 'GB';
DELETE FROM `fl_ipgeo_locations` WHERE `Country_code` <> 'GB';

screenshot after 1-st request: https://prnt.sc/rzoms7
screenshot after 2-nd request: https://prnt.sc/rzonm3

Thanks Victor, that works great!

Just one other thing, when using the Search by Distance plugin. When typing in a location it is still offering locations from all around the world as suggestions, how do I limit it to just locations and Post Codes in the United Kingdom?

Many thanks

I have checked Search by distance on your site and I see locations into Autocomplete field form the United Kingdom only.

Why do we need this plugin? Without it the website geo filter still works great. Is there any greater benefit using it?

Thank you

Quote:

---

Originally Posted by Viktor

I have checked Search by distance on your site and I see locations into Autocomplete field form the United Kingdom only.

---

Hi Viktor,

Thanks for your help.

If I start to search for a location, say London, I get results from all around the world. I've attached a screen shot for the London search.



Any help would be great.

Many thanks

Would you please send ftp access to my PM I will check and solve it.

Hello Viktor,

Could you please explain this thread further?

What exactly do you want me to explain to you?

Quote:

---

Originally Posted by Viktor

Need to run 2 mysql queries in turn:

DELETE `T1` FROM `fl_ipgeo` AS `T1` LEFT JOIN `fl_ipgeo_locations` AS `T2` ON `T1`.`Loc_ID` = `T2`.`Loc_ID` WHERE `T2`.`Country_code` <> 'GB';
DELETE FROM `fl_ipgeo_locations` WHERE `Country_code` <> 'GB';

screenshot after 1-st request: https://prnt.sc/rzoms7
screenshot after 2-nd request: https://prnt.sc/rzonm3

---

I just need more explanation regarding how to run 2 mysql queries inorder to minimize the size of locations/IP Geo database for just one country?