First up, thanks to everyone in this thread… what i post is what took me a while to figure out (character set in load data and some other errors in the original script (like capital I in countryInfo etc).
Original Post Over : http://forum.geonames.org/gforum/posts/list/45/732.page
save as import.sql (update)
Code: CREATE DATABASE geonames; USE geonames;