[Qgis-user] Export SHP to mySQL

[Vicent García]

Ok!

 

Thanks to everyone!

 

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 16:51
Para: qgis-user at lists.osgeo.org
Asunto: Re: [Qgis-user] Export SHP to mySQL

 

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 <mailto: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/7ef0f7d1/attachment.html>