[gdal-dev] OGR to Mysql problems
neteler at osgeo.org
Thu Mar 4 10:57:43 EST 2010
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
> -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.
More information about the gdal-dev