[MS4W-Users] about ogr2ogr

Jeff McKenna jmckenna at gatewaygeomatics.com
Mon Sep 14 07:28:50 EST 2009

Rangga Negara wrote:
> i can't convert shp file to mysql,
> C:\ms4w>ogr2ogr -f MySQL MySQL:a,user=root,password= -lco 
> GEOMETRT_NAME=SHAPE c:\ms4w\apache\htdocs\trial\peta_tab\a\a_region.shp
> ERROR 1: MySQL error message:The used table type doesn't support SPATIAL 
> indexes
>  Description: ALTER TABLE `a_region` ADD SPATIAL INDEX(`SHAPE`)
> ERROR 1: Terminating translation prematurely after failed
> translation of layer a_region (use -skipfailures to skip errors)
> i don't have any clue about that.

I don't really know, but I would read the MySQL OGR driver page 
(http://www.gdal.org/ogr/drv_mysql.html)...which mentions the spatial 
index and creation options.


Jeff McKenna
FOSS4G Consulting and Training Services

More information about the MS4W-Users mailing list