<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Messages posted by "zeman"]]></title>
		<link>http://forum.geonames.org/gforum/posts/listByUser/298.page</link>
		<description><![CDATA[Messages posted by "zeman"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Re:Importing the Geonames Dump into mysql</title>
				<description><![CDATA[ I had much better luck using the mysqlimport tool.

mysqlimport -h host -u username -ppassword --fields-terminated-by='\t' --lines-terminated-by='\n' --columns='geonameid, name, ansiname, alternames, latitude, longitude, feature_class, feature_code, country_code, cc2, admin1_code, admin2_code, population, elevation, gtopo30, timezone, modification_date' --local database /path/geonames.txt

Use ftp or wget on the server to grab the dump file, upload it to your server, uncompress and rename to match your table.

Replace the following with your info:
host
username
password (no space between the -p option and password)
database
/path/geonames.txt (path to your file on server)

<b>Important:</b> double check via phpmyadmin that both the collation of the whole database and the table is set to "utf8_general_ci" via the "operations" tab before you import.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/preList/80/1977.page#1977</guid>
				<link>http://forum.geonames.org/gforum/posts/preList/80/1977.page#1977</link>
				<pubDate><![CDATA[Tue, 1 May 2007 06:01:33]]> GMT</pubDate>
				<author><![CDATA[ zeman]]></author>
			</item>
			<item>
				<title>Re:I have problems using the webservice with blanks and special characters</title>
				<description><![CDATA[ I'm using utf8_encode in php to encode strings. It works fine most of the time but I'm getting the occasional odd results like the following when searching for Ryūō Japan...

http://ws.geonames.org/search?name_equals=Ry%u016B%u014D&country=JP&fcode=ppl&fcode=pplc&fcode=ppla&style=full

<status message="missing parameter" value="12"/>]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/preList/8/1972.page#1972</guid>
				<link>http://forum.geonames.org/gforum/posts/preList/8/1972.page#1972</link>
				<pubDate><![CDATA[Mon, 30 Apr 2007 10:58:18]]> GMT</pubDate>
				<author><![CDATA[ zeman]]></author>
			</item>
	</channel>
</rss>