GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
Messages posted by: vaseem  XML
Profile for vaseem -> Messages posted by vaseem [2]
Author Message
General -> import countyInfo.txt postgresql -> Go to message
thank you i got the solution

vaseem
General -> import countyInfo.txt postgresql -> Go to message
hi ,
i am importing the alcountries.txt into mysql using gui sql tool, i used the command load

LOAD DATA INFILE'C:\Documents and Settings\kim\Desktop\king-test-thu\geonames-66000-test.txt' INTO TABLE geonames.geoname (geonameid,name,asciiname,alternativenames,latitude,longitude,fclass,fcode,country,cc2, admin1,admin2,admin3,admin4,population,elevation,gtopo,timezone,moddate);

i am getting errors as table not found File 'Cocuments and SettingskimDesktopking-test-thugeonames-66000-test.txt' not found (Errcode: 2)

thanks in advance
khan
 
Profile for vaseem -> Messages posted by vaseem [2]
Go to:   
Powered by JForum 2.1.5 © JForum Team