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
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.
Thanks
Best regards
Nicol
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
