[Talk-in] Importing OSM to mysql

[Arjun Ram]

I have been trying import osm to mysql but the process seems painful. Looks
like osmosis has changed and instructions have been not been updated for
starters.
I have downloaded the cloud made files and and am trying to import them.

I have also downloaded the nightly build of osmosis from
http://dev.openstreetmap.org/~bretth/osmosis-build/

and the DB schema at
http://wiki.openstreetmap.org/wiki/Osmosis#DB_Schema

if I run osmosis as follows
./osmosis --read-xml file=../../india.osm --write-apidb dbType="mysql"
database="api06_test" user="blah" password="hello"

it chokes complaining
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Database version
mismatch. The schema is missing migrations

if I use the  validateSchemaVersion=no
it chokes complaining constraints
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot add or update a child row: a foreign key constraint fails
(`api06_test/current_way_nodes`, CONSTRAINT `current_way_nodes_ibfk_2`
FOREIGN KEY (`node_id`) REFERENCES `current_nodes` (`id`))

Has anyone been able successfully import it into mysql?

Any help would be greatly appreciated!

Cheers
-- 
Arjun Ram
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-in/attachments/20090904/0175eaac/attachment.html>