<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Offline GeoNames database"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Offline GeoNames database"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Offline GeoNames database</title>
				<description><![CDATA[ I'm sorry if this is a stupid question or if I've missed the answer already posted, but I'm trying to create an offline version of geonames for my team. I've downloaded the allCountries dump and loaded it into a mysql database, but I don't know what to do with it now. The way I see it, there are two major options that might be viable given that I'm not at all a programmer:

1. I've already installed MediaWiki, so it might be possible to load GeoNames into Mediawiki (creating a GeoNames Wiki did not load the information from the GeoNames MySQL database into that wiki).
2. Create an HTML page that would use PHP to search and access the information in GeoNames. 

We primarily need the alternate names, latitude, and longitude fields. It would be nice to be able to search for the alternate names as well as the official name, but not absolutely critical.

Does anyone have code already for this and could you explain to me how to use it, or could someone possibly point me in the direction of a good tutorial for this sort of thing? I've never used PHP or HTML.

Thank you very much in advance!]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/3722.page#11107</guid>
				<link>http://forum.geonames.org/gforum/posts/list/3722.page#11107</link>
				<pubDate><![CDATA[Fri, 30 Dec 2011 09:23:31]]> GMT</pubDate>
				<author><![CDATA[ kschindler]]></author>
			</item>
			<item>
				<title>Re:Offline GeoNames database</title>
				<description><![CDATA[ Greetings -

Since you have it loaded into MySQL the simplest thing is to learn to write SQL queries (SELECT statements) to show the data you want. 

Use one of the graphical front ends (if running windows) for MySQL that lets you write queries and proceed to query data to get what you want.

If using linux then use the MySQLadmin web interface to get to the data.

Set up users (for all of your team) to access the MySQL data, give them all the graphical (or web) front end for and show them how to query the for the data.

That will be the quickest way to get to the data.

You will have a learning curve whatever you choose, but that will be shortest one.

Regards,
Roberto Artigas
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/3722.page#11112</guid>
				<link>http://forum.geonames.org/gforum/posts/list/3722.page#11112</link>
				<pubDate><![CDATA[Wed, 4 Jan 2012 07:43:34]]> GMT</pubDate>
				<author><![CDATA[ artigas]]></author>
			</item>
	</channel>
</rss>