[MS4W-Users] about ogr2ogr

[Jeff McKenna]

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


-- 
Jeff McKenna
FOSS4G Consulting and Training Services
http://www.gatewaygeomatics.com/