MySQL spatial support lacks of many critical features, including
projections and other basic functions. I have tried to use it in
couple of projects with similar requirement, but found that changing
requirement to use PostGIS turned out to be easier solution.
If you still really want it, I would use osm2pgsql to import data to
postgis, then export Shapefiles from it and import them using some
shape to mysql script. In theory ogr2ogr should enable also direct
postgis>mysql conversion.
If you need direct tool and can write Python then try to edit
http://imposm.org/docs/imposm/latest/. Mysql and postgis
insert-statements should follow same standard, in theory at least it
should not be too complicated.
Jaak
2011/5/26 Leonid Khaylov :
> Hello!
>
>
>
> After days of surfing in the internet I couldn't find for MySQL any tool
> similar to osm2pgsql for Postgres. All I want to do is to visualize the OSM
> data for Germany on GeoServer with MySQL DB. The tools I found like Osmosis
> and osm2sql save the data in a non-spatial schema, that's why GeoServer
> can't visualize it.
>
>
>
> Can anybody make a clear statement, whether such tool for MySQL exists? I
> know that MySQL support is not well tested on the GeoServer and that
> Postgres is a preffered DB, but MySQL is a requirement in my case.
>
>
>
> Would appreciate any help!
>
>
>
> Thank you!
>
> Leonid Khaylov
>
> Student
>
> Computer Science
>
> TU Darmstadt
>
> ___
> talk mailing list
> talk@openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>
>
--
Jaak Laineste
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk
