You are not logged in.
- Topics: Active | Unanswered
Announcement
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***
#1 2008-09-01 00:05:37
- john_ag
- Member
- Registered: 2008-09-01
- Posts: 2
Nobody ever converted .osm to mysql ? How can i ?
Hi,
i´d like to import .osm data into a mysql database. Can´t believe there is no script / nobody has ever done it ? Or should i try Osm2pgSQL and then convert it to mysql ?
Offline
#2 2008-09-01 02:56:19
- john_ag
- Member
- Registered: 2008-09-01
- Posts: 2
Re: Nobody ever converted .osm to mysql ? How can i ?
I found it myself: It can be done with Osmosis. However, the import just doesn´t work for me. Will try the dev. mailing list too - don´t know wich place is better. The script always complains about a missing table "dtabasename.shema_info".
Offline
#3 2008-09-01 08:25:24
- emj
- Member
- From: .se (59.3N17.99E) 0735969076
- Registered: 2006-06-18
- Posts: 949
Re: Nobody ever converted .osm to mysql ? How can i ?
Postgres and mysql are used for different things, rendering and editting.
The mysql database is used by the ruby on rails app, this is used to do editing of the OSM data. Rails is responsible for setting up the database, if you look in the wiki there are several pages describing different ways of setting up openstreetmap and mysql.
The postgres db is used for rendering, it contains a subset of the databse, optimized specifically for rendering. This databse is not used in the same way at all as the mysql one.
Offline