On 15 February 2012 11:06, Brett Henderson <[email protected]> wrote: > On 15 February 2012 19:45, Simon Nuttall <[email protected]> wrote: >> >> > Do you have to use MySQL? Osmosis still contains the MySQL but it is no >> > longer tested. >> >> All of CycleStreets uses MySQL so abandoning that would require a lot >> of work. I've learned my way around MySQL now and know what to avoid >> and what to use. I'd have to go through the same process with Postgres >> - and we did start down that path a couple of years ago when it looked >> like you were abandoning MySQL. >> >> > It may be necessary to update the MySQL schema to match the >> > PostgreSQL schema. >> >> OK, I might look into that, but I think it is more likely that we'll >> just stick with 0.39 of Osmosis for the time being. > > > Okay, that's fair enough. > > I think renaming your columns should be sufficient, but let me know if you > try it and it turns out to be more complicated.
Yes, that was it. I did change the id columns (and the indexes that referred to id) into xxx_id in about a dozen places in the MySQL schema file, by comparison with the Postgres schema. I now have an import running in MySQL with Osmosis 0.40.1 Many thanks, Simon _______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
