remove countries and zones

[Nanettedp]

Is there any way to remove countries and zones in bulk? Our company only sell in within the boarders of South Africa, so I need to remove all non relevant zones and countries, but removing them one by one is tedious. Please help

[SoftDux]

You'd be able todo this from the MySQL DB, if you know some SQL commands :)

[Webskipper]

I need help with this also.

I want to create a NOSHIP Zone.

I have downloaded one of the smaller sized SQL files to add a Zone.

I have also trimmed a list of ISO codes.

What information do I need to modify the SQL list of Countries to include Countries I will not do business with?

Which do I need?

ISO
2-alpha
ISO
3-alpha
IANA
Internet
UN
Vehicle
IOC
Olympic