[Qgis-user] Export SHP to mySQL

[Marco Lechner - FOSSGIS e.V.]

read this:

https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
Marco

Am 05.03.2016 um 14:55 schrieb Vicent García:
>
> Hi,
>
>  
>
> I’ve tried to do that (shp2mysql), but I got this error:
>
> “ERROR 1: MySQL error message: The used table type doesn’t suport
> SPATIAL indexes. Description: ALTER TABLE ‘shapefile’ ADD SPATIAL
> INDEX(‘poligon_columna’)
>
> ERROR 1: Terminating translation prmaturely after failed translation
> of layer ESP_adm4 (use -skipfailures to skip errors)”
>
>  
>
> Sorry, but it’s my first time that I use this command and I’m a bit lost.
>
>  
>
> Thanks,
>
>  
>
> Vicent.
>
>  
>
> *De:*Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] *En nombre
> de *Marco Lechner - FOSSGIS e.V.
> *Enviado el:* dissabte, 5 de març de 2016 11:16
> *Para:* qgis-user at lists.osgeo.org
> *Asunto:* Re: [Qgis-user] Export SHP to mySQL
>
>  
>
> Hi Vincent,
>
> its possible using ogr2ogr (and should be possible using QGIS -> Layer
> save as ... as well.
>
> # shp2mysql
> ogr2ogr -f MySQL MySQL:<my_db>,user=<username>,password=<mypass>
> <path2shape>.shp -nln <target_table> -overwrite -update -lco
> GEOMETRY_NAME=geom -lco ENGINE=MyISAM -lco CHARSET=UTF-8
>
> # info about table
> ogrinfo MySQL:<my_db>,user=<username>,password=<mypass> <table_name> -so
>
> # mysql2shp
> ogr2ogr -f "ESRI Shapefile" <path2shape>.shp
> MySQL:<my_db>,user=<username>,password=<mypass> -sql "SELECT * from
> <my_table>"
>
> Hope this helps
>
> Marco
>
> Am 05.03.2016 um 08:32 schrieb Vicent García:
>
>     Hi Community,
>
>      
>
>     Does anyone know how to export shapefile files to mySQL? I read
>     some things about the topic on the Internet but no clear solutions
>     I’ve found.
>
>      
>
>     Thanks,
>
>      
>
>     Vicent.
>
>
>
>
>     _______________________________________________
>
>     Qgis-user mailing list
>
>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>
>     List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>     Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160305/889884ce/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x6A30F373.asc
Type: application/pgp-keys
Size: 3149 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160305/889884ce/attachment.key>