:O I never thought that option would be there. Sadly, OGR2OGR seems to use the 
auto-increment option, so the server request an index, anyone except the geom 
column. I try use the FID value, but still can't set the index.
Thx!

    El lunes, 16 de mayo de 2022, 04:19:38 p. m. GMT-4, Even Rouault 
<[email protected]> escribió:  
 
  
Felipe,
 
If you look at https://gdal.org/drivers/vector/mysql.html, you can see a 
SPATIAL_INDEX layer creation being mentioned.
 
So try adding -lco SPATIAL_INDEX=NO to your ogr2ogr command line
 
Even
 
 Le 16/05/2022 à 22:13, Felipe Matas via gdal-dev a écrit :
  
 
 Hi, I'm trying to use Dolt (a new db) with spatial data, it works with a MySQL 
syntax/core, so I'm able to use ogr2ogr to export data to the database, well 
half of it, the db actually don't support spatial index, and ogr2ogr use a 
spatial index, is there a way to upload a spatial file without set a spatial 
index with ogr2ogr? I check the doc, sadly I wasn't able get an answer.
  
  Thx.
   
  _______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev
 -- 
http://www.spatialys.com
My software is free, but my time generally not.   
_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to