[OSM-dev] hello! need expert to hand hold me with DB setup

[Nick Whitelegg]

On Friday 15 Feb 2008 10:45, Fire Girl wrote:
> Hello out there tonight -- I was posting on here before and received some
> good advice, which led me to lots of research and i think i finally
> decided on wanting to get the Planet.OSM file inserted into a MYSQL
> database, and go onwards from there.  I actually have MYSQL running on a
> Windows Apachae emultation, and it works great and feel very comfortable
> with it.  I also have a Linux machine, which I am not as comfortable
> with... but starting to get the hang of shell commands, and setting
> things up.
>

Maybe your best bet is to use a PostGIS database and osm2pgsql, which takes 
a .osm file and populates a PostGIS database. The only issue is postgis can 
be a bit of a pain to set up, but if there are pre-built packages for your 
platform it's a *lot* easier. Are you on windows? I'm guessing there's a 
prebuilt postgis for windows.

See http://wiki.openstreetmap.org/index.php/Mapnik

for more details.

Nick