Putting Countries Back Into Database

[railroadguy]

My client said they will NEVER sell outside the US so I simply removed all the countries from the database. Now, they have decided to sell worldwide and I am not sure how to write the statement to put the countries back into the database base.

 

With a gold copy, can I remove everything but INSERT INTO countries VALUES and reload that way?

[FIMBLE]

use something like worldzones contribution it has an SQL file with most of the zones around the globe, remove the USA and the table structure as you already have this in your database, then upload to the db via phpmyadmin

Back up first though

[railroadguy]

To late :rolleyes: I was able to insert the

 

DROP TABLE IF EXISTS countries;

CREATE TABLE countries (

 

and all the rest from a gold copy.

[FIMBLE]

thats fine so long as you were successful :- )

Nic