Re-Adding countries in one by one question

When I first started using Zen Cart a few years back, I only wanted to ship to the USA so I deleted everything else. I've added a few countries in manually, but it is time consuming.

Is there a way to quickly add in 1 additional country at a time?

Could I just import, say Australia today, then Japan tomorrow?

If so, could someone show me how to do that?

Using ZC 1.3.9h

Thanks!

Find the INSERT INTO countries section in the zc_install sql file for mysql_zencart.sql and copy-paste those into your phpMyAdmin.

If you start adding them in any other way you'll end up with mismatched country_id values in all your customer/address records, and then things will be out of sync.

Thanks! Is there something similar for provinces, or do those have to be added manually?

Having this for all the European countries would be really nice.. And Australia.

If not, we will do it manually.. but I figured I'd ask.

Thanks a lot