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 <leonid.khay...@googlemail.com>: > 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
