[osmosis-dev] read-pbf output error after upgrade from 0.39 to 0.40.1

[Simon Nuttall]

On 15 February 2012 11:06, Brett Henderson <brett at bretth.com> wrote:
> On 15 February 2012 19:45, Simon Nuttall <simon.nuttall at gmail.com> 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