<html><head></head><body><div class="ydp9e3e2dd2yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div dir="ltr" data-setdir="false">: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.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Thx!<br></div><div><br></div>
</div><div id="yahoo_quoted_3362006002" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
El lunes, 16 de mayo de 2022, 04:19:38 p. m. GMT-4, Even Rouault <even.rouault@spatialys.com> escribió:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv9021110328"><div>
<p>Felipe,</p>
<p>If you look at <a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://gdal.org/drivers/vector/mysql.html" class="yiv9021110328moz-txt-link-freetext">https://gdal.org/drivers/vector/mysql.html</a>, you
can see a SPATIAL_INDEX layer creation being mentioned.</p>
<p>So try adding -lco SPATIAL_INDEX=NO to your ogr2ogr command line</p>
<p>Even<br clear="none">
</p>
<div class="yiv9021110328moz-cite-prefix">Le 16/05/2022 à 22:13, Felipe Matas via
gdal-dev a écrit :<br clear="none">
</div>
<blockquote type="cite">
</blockquote></div><div><div id="yiv9021110328yqt20475" class="yiv9021110328yqt4506623652"><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;" class="yiv9021110328yahoo-style-wrap">
<div dir="ltr">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.<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Thx.<br clear="none">
</div>
</div></div>
<br clear="none">
<fieldset class="yiv9021110328moz-mime-attachment-header"></fieldset>
<pre class="yiv9021110328moz-quote-pre">_______________________________________________
gdal-dev mailing list
<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:gdal-dev@lists.osgeo.org" target="_blank" href="mailto:gdal-dev@lists.osgeo.org" class="yiv9021110328moz-txt-link-abbreviated">gdal-dev@lists.osgeo.org</a>
<a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" class="yiv9021110328moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
<pre class="yiv9021110328moz-signature">--
<a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="http://www.spatialys.com" class="yiv9021110328moz-txt-link-freetext">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</div></div></div>
</div>
</div></body></html>