Import Geoplanet to MySQL

ddl.sql

CREATE TABLE `places` (
  `woeid` varchar(15) NOT NULL,
  `iso` varchar(6) NOT NULL,
  `name` text NOT NULL,
  `language` varchar(6) NOT NULL,
  `type` varchar(15) NOT NULL,
  `parent` varchar(15) NOT NULL,
  PRIMARY KEY (`woeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aliases` (
  `woeid` varchar(15) NOT NULL,
  `name` text NOT NULL,
  `name-type` varchar(6) NOT NULL,
  `language` varchar(6) DEFAULT NULL,
  KEY `woeid` (`woeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

import.sh

ln -s geoplanet_places_*.tsv places.tsv
mysqlimport -uroot -p geoplanet --ignore-lines=1 --fields-optionally-enclosed-by=\" -L places.tsv