<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "How to insert allCountries.txt into a Mysql DB?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "How to insert allCountries.txt into a Mysql DB?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>How to insert allCountries.txt into a Mysql DB?</title>
				<description><![CDATA[ Hi there,

I would like to know how to insert the big allCountries.txt file into a mysql db. Step by Step cause I ain't a pro in managing a db...

I have phpmyadmin + easyphp.

Thank you!]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/238.page#1274</guid>
				<link>http://forum.geonames.org/gforum/posts/list/238.page#1274</link>
				<pubDate><![CDATA[Fri, 8 Dec 2006 03:36:36]]> GMT</pubDate>
				<author><![CDATA[ yello]]></author>
			</item>
			<item>
				<title>Re:How to insert allCountries.txt into a Mysql DB?</title>
				<description><![CDATA[ Hi Yello

There is this faq entry on creating a table :
http://forum.geonames.org/gforum/posts/list/80.page

and a thread about synchronizing your db with geonames :
http://groups-beta.google.com/group/geonames/browse_thread/thread/26d84fc11a2c78cc?hl=en

Hope this helps

Cheers

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/238.page#1275</guid>
				<link>http://forum.geonames.org/gforum/posts/list/238.page#1275</link>
				<pubDate><![CDATA[Fri, 8 Dec 2006 07:31:57]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:How to insert allCountries.txt into a Mysql DB?</title>
				<description><![CDATA[ by "synchronizing your db" you mean I just copy/paste that code in a text editor to make a php file and run it on my machine?

Excuse my newbie questions  :wink: ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/238.page#1277</guid>
				<link>http://forum.geonames.org/gforum/posts/list/238.page#1277</link>
				<pubDate><![CDATA[Fri, 8 Dec 2006 13:45:18]]> GMT</pubDate>
				<author><![CDATA[ Anonymous]]></author>
			</item>
			<item>
				<title>Re:How to insert allCountries.txt into a Mysql DB?</title>
				<description><![CDATA[ It should also be possible to use ftp to upload the file to the server. And than use phpmyadmin to send a sql command: LOAD DATA INFILE 

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

You should try it first local (e.g. XAMPP).  

Greetings ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/238.page#1279</guid>
				<link>http://forum.geonames.org/gforum/posts/list/238.page#1279</link>
				<pubDate><![CDATA[Fri, 8 Dec 2006 15:32:54]]> GMT</pubDate>
				<author><![CDATA[ Anonymous]]></author>
			</item>
			<item>
				<title>Re:How to insert allCountries.txt into a Mysql DB?</title>
				<description><![CDATA[ Hi

With synchronization I meant how to get the newest modifications of geonames into your data base without having to reload the full dump. But you have to load it first, before thinking about this.

For copy/paste the data set may be too large and you should look at the mysql load functions if you don't know them.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/238.page#1284</guid>
				<link>http://forum.geonames.org/gforum/posts/list/238.page#1284</link>
				<pubDate><![CDATA[Fri, 8 Dec 2006 19:01:44]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>