Ok!
Thanks to everyone! Vicent. De: Qgis-user [mailto:[email protected]] En nombre de Marco Lechner - FOSSGIS e.V. Enviado el: dissabte, 5 de març de 2016 16:51 Para: [email protected] 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:[email protected]] En nombre de Marco Lechner - FOSSGIS e.V. Enviado el: dissabte, 5 de març de 2016 11:16 Para: [email protected] <mailto:[email protected]> 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 [email protected] <mailto:[email protected]> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
