GeoNames Forum

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!

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

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

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

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