Hi Eby,

Sorry for the trouble in understanding my question.
I'm trying to create MySQL database, but the scripts in osmosis script
folders are specifically for creating PostgreSQL.

My search is to find out MySql version of "pgsql_simple_schema_0.6.sql".
so that I can create and initialize database like they have mentioned in
this link <http://wiki.openstreetmap.org/wiki/Osmosis/PostGIS_Setup>
OK, now that makes sense. Still, I'm sorry to have to tell you that there is no easy way to use MySQL with Osmosis. Both the "simple" and the "snapshot" schema are exclusively for PostgreSQL (PostGIS is an PostgreSQL plugin, after all :)). It is not coincidence that the page you linked has "PostgreSQL" written all over it :)

So, if you want to use this Osmosis feature, you need PostgreSQL as the DB server, and not MySQL or any other DBMS for that matter.

I'm afraid that if you need MySQL support, you will have to program it yourself. I'm not even sure it can be done at all - I don't have any experience using MySQL for geospatial data.

Bye
Igor

_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev

Reply via email to