Did you compile it with --fast?
Free Zip Code Database Import
When you need a zip code database for the US you should get it from here
http://www.free-zipcodes.com/
But you shouldn't spend time trying to install all the required perl (sigh) libs needed to import it into MySQL.
Simply create the table structure
CREATE TABLE zipcodes (
zipcode INT NOT NULL PRIMARY KEY,
latitude FLOAT(10,8),
longitude FLOAT(10,8),
state VARCHAR(2),
city VARCHAR(128),
county VARCHAR(128)
);Then fire up Sequel Pro. File-> Import. Set "Fields terminated by" to || and uncheck "First line contains fields names."
As a bonus Sequel Pro supports ssh tunneling out of the box so you can do it directly to firewalled DBs.
As always make sure you back up your DB first incase of failure.
Comments
Post new comment