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
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=911 ;
–
– 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