[osmosis-dev] Create and Initialize SQL Database for osmosis

[Igor Podolskiy]

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