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
_______________________________________________ Talk-in mailing list Talk-in@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-in
