[Qgis-user] Export SHP to mySQL

[Marco Lechner - FOSSGIS e.V.]

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
> 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/de51545e/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/de51545e/attachment.key>