How to Import these countries into my Database?

How to Import these countries into my Database?

I am using a WordPress theme with locations, it will take a long time to manually add each country, so I wanted to import them into the database.

Here is what I have:

I exported this from my database to look at the code:

– Database: 942392_9c4e

– Table structure for table wp_term_taxonomy

CREATE TABLE IF NOT EXISTS wp_term_taxonomy (
term_taxonomy_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
term_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
taxonomy varchar(32) NOT NULL DEFAULT ‘’,
description longtext NOT NULL,
parent bigint(20) unsigned NOT NULL DEFAULT ‘0’,
count bigint(20) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (term_taxonomy_id),
UNIQUE KEY term_id_taxonomy (term_id,taxonomy),
KEY taxonomy (taxonomy)

– Dumping data for table wp_term_taxonomy

INSERT INTO wp_term_taxonomy (term_taxonomy_id, term_id, taxonomy, description, parent, count) VALUES
(602, 602, ‘ad_location’, ‘Noosa’, 0, 2);

I have currently 1 location = Noosa

Here is my country list, showing just the first few countries:

INSERT INTO `countries` (`country_id`, `name`) VALUES

 (1, 'Afghanistan'),
 (2, 'Albania'),
 (3, 'Algeria'),
 (4, 'American Samoa'),
 (5, 'Andorra'),
 (6, 'Angola'),
 (7, 'Anguilla'),
 (8, 'Antarctica'),
 (9, 'Antigua and Barbuda'),
 (10, 'Argentina'),
 (11, 'Armenia'),
 (12, 'Armenia'),
 (13, 'Aruba'),
 (14, 'Australia'),

How do I import the countries list ? To add them to the ‘ad_location’, ‘Noosa’,

all help greatly appreciated :slight_smile: