Restoring missing zones in zones table

[ronlee67]

A few years ago when I first implemented a Zencart shop I did not fully understand how zones were to be configured.
I removed many county listings for the United Kingdom from the zones table. Now I need to restore these and start configuring my zones correctly.

Is there a way (perhaps with a sql script) to update the zones table in an existing shop with all of the counties/provinces/states etc. and their code as they were originally provided in the installation package?

[kobra]

Do a test install of the same version
export the zones table from it and import same into the install where they are missing

[fairestcape]

You need to be aware of the RELATIONAL nature of the database before you tackle this.

SEVERAL tables are involved, and if you get the ID's wrong, you could seriously compromise a range of things - including customer addresses, address formats, countries, states/provinces, taxes, shipping and zone definitions.