Hi Even,
thanks a lot! That did the trick.
Best Nicol
Am Dienstag, den 08.10.2013, 22:05 +0200 schrieb Even Rouault:
> Le mardi 08 octobre 2013 21:37:54, Jukka Rahkonen a écrit :
> > Nicol Hermann <gdal <at> geoworld.de> writes:
> > > Hello list,
> > >
> > > I am trying to batch load GPX files from a directory into a mysql
> > > database.
> > > In order to avoid duplicates I am using the '-overwrite' layer create
> > > option.
> > > The following line throw the error message
> > >
> > > ogr2ogr -overwrite -f MYSQL
> > > 'MYSQL:dbname,host=localhost,user=me,password=' ${file} -lco
> > > GEOMETRY=AS_XYZ -lco engine=MYSIAM -sql "SELECT name FROM tracks"
> > >
> > > MySQL error message:The used table type doesn't support SPATIAL indexes
> > > Description: ALTER TABLE `tracks` ADD SPATIAL INDEX(`SHAPE`)
> > >
> > > although I have also specified the
> > > -lco engine=MYSIAM
>
> This is a typo. Should be : -lco ENGINE=MyISAM
>
> > >
> > > parameter.
> > > Any idea how to change the line to avoid this error?
> > >
> > > If I am changing the parameter to '-append' the import works with the
> > > downside to have duplicates in if I rerun the script.
> >
> > This is not exactly an answer to your question, but you -overwrite option
> > does not overwrite features on the layer but it overwrites the whole layer.
> > So if you manage you command to work otherwise, in the end you will have
> > only your last GPX file in the database. Use append instead and delete the
> > dublicates with SQL afterwards.
>
> For append/update without creating duplicates into an existing target layer,
> you can try the
> http://svn.osgeo.org/gdal/trunk/gdal/swig/python/samples/ogrupdate.py script.
>
> >
> > -Jukka Rahkonen-
> >
> > > Thanks
> > > Best regards
> > > Nicol
> >
> > _______________________________________________
> > gdal-dev mailing list
> > gdal-dev@lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
