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] > *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 > > >
0x6A30F373.asc
Description: application/pgp-keys
_______________________________________________ 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
