you can run this sql statement in phpmyadmin
Code:
DELETE FROM xcart_countries WHERE "code" != "us";
or if you empty the whole countries table then just run this statement to just add US
Code:
INSERT INTO xcart_countries VALUES ('United States','US','English','iso-8859-1','Y','N','');
Be careful and backup the db first