I am trying to import my ESRI-shapefile with OGR2OGR to an existing mysql table. This works fine but unfortunately only the featureID and the geometry data is exported. How do I add the labels of the different polygons? These are stored in the .dbf-File if I am not mistaken. I am using the following command:
ogr2ogr -f MySQL MYSQL:Polygons,host=localhost,user=user,password=user,port=3306 -nln route -a_srs EPSG:4326 -append /home/Fields3.shp
if using ogrinfo on the file it tells me:
INFO: Open of `Fields3.shp' using driver `ESRI Shapefile' successful. 1: Fields3 (Polygon)
How can I get the addition information into Mysql? The Shapefile is created using Qgis 2.0 with standard settings.