GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Import txt on mysql  XML
Forum Index -> General
Author Message
john93



Joined: 31/05/2017 02:00:02
Messages: 1
Offline

Hello, I have the FR.zip file I would like to know how to import it into a database on mysql
jonny512379



Joined: 11/02/2017 20:41:32
Messages: 10
Offline

Hello John

I have been doing similar.
there is no .sql file ready made for you to do this (as different users will want different things), but importing data is easy enough.

you may want to read this http://forum.geonames.org/gforum/posts/list/732.page but replace the file name in the "LOAD DATA INFILE" parts with the extracted FR file.

MySQL WorkBench should help you do this, but it is probably possible in phpmyadmin

hope this helps

Jon
[Email]
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team