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

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

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

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

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 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

Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team