<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<pre>Hi Markus, after your email I have some new results:<br><br>1)With ogr2ogr:<br>SET GISBASE=C:\OSGeo4W\apps\grass\grass-6.4.0svn<br><br>ogr2ogr -f mysql MYSQL:geodados,user=root,password=rcamargo,host=localhost<br>/grassdata/utmwgs23/geral/vector/areas_recuperacao_trabalhado/head <br>-overwrite -lco spatial_index=no -nln areas<br><br>It worked very well!! I think the problem was with the GISBASE path (the \ / mixture and the "a").<br><br><br>2)With v.out.ogr:<br>v.out.ogr --verbose input=areas_recuperacao_trabalhado@geral <br>type=area dsn=MYSQL:geodados,user=root,password=rcamargo,host=localhost <br>format=MySQL olayer=teste3 -c lco=spatial_index=no<br><br>I still get the error: <br>"ERROR 1: MySQL error message:Duplicate entry '1' for key 'OGR_FID'"<br>and only one row created at Mysql<br><br>My GRASS is the latest OSGeo4W version.<br><br>Pablo.<br><br><br><br>On Thu, Mar 4, 2010 at 1:27 PM, Pablo Carreira<br><pablotcarreira@hotmail.com> wrote:<br>> Hi Even,<br>> I don't know much of programming. I'am using the GRASS v.out.ogr tool to<br>> export from GRASS to Mysql.<br>> Do you think it's a GRASS bug?<br> <br>Hi Pablo,<br> <br>how old is your GRASS version?<br> <br>> I had tryied ogr2ogr from command line in windows but I got this error:<br>><br>> c:\>ogr2ogr -f mysql MYSQL:geodados,user=root,password=xxxxxx,host=localhost<br>> /grassdata/utmwgs23/geral/vector/areas_recuperacao_trabalhado/head<br>> -overwrite -lco spatial_index=no<br>><br>> Warning 1: GRASS warning: Lineā¦ of ellipsoid table file<br>> <c:\osgeo4w\apps\grass\grass-6.a.0svn/etc/ellipse.table> is invalid<br> <br>I observe that there is a mixture of \ and / mixed... (also<br>grass-6.a.0svn is funny,<br>note the "a"?).<br> <br>OSGeo4W-GRASS has been updated recently and should have all needed fixes<br>for the \ and / confusion. Perhaps it comes from the GRASS-GDAL plugin? I darkly<br>remember that it opens the ellipsoid table.<br> <br>Markus</pre> <br /><hr />Fale com seus amigos do Messenger direto da Caixa de Entrada do Hotmail. <a href='http://www.windowslive.com.br/public/tip.aspx/view/24?product=1&ocid=HotmailPlan:WindowsLive:Hotmail:Tagline:1x1:DicasWL' target='_new'>Clique aqui</a></body>
</html>