[gdal-dev] OGR to Mysql problems

[Markus Neteler]

On Thu, Mar 4, 2010 at 4:51 PM, Pablo Carreira
<pablotcarreira at hotmail.com> wrote:
> Hi Markus, after your email I have some new results:
>
> 1)With ogr2ogr:
> SET GISBASE=C:\OSGeo4W\apps\grass\grass-6.4.0svn
>
> ogr2ogr -f mysql MYSQL:geodados,user=root,password=rcamargo,host=localhost
> /grassdata/utmwgs23/geral/vector/areas_recuperacao_trabalhado/head
> -overwrite -lco spatial_index=no -nln areas
>
> It worked very well!!

So the plugin seems to work ok, good.

> I think the problem was with the GISBASE path (the \ /  mixture and the "a").
>
>
> 2)With v.out.ogr:
> v.out.ogr --verbose input=areas_recuperacao_trabalhado at geral
> type=area dsn=MYSQL:geodados,user=root,password=rcamargo,host=localhost
> format=MySQL olayer=teste3 -c lco=spatial_index=no
>
> I still get the error:
> "ERROR 1: MySQL error message:Duplicate entry '1' for key 'OGR_FID'"
> and only one row created at Mysql
>
> My GRASS is the latest OSGeo4W version.

Please file a bug report with the needed details.

Markus