[gdal-dev] Importing and exporting shapefiles in mySQL with OGR

[Jeff McKenna]

On 11-01-17 3:25 AM, "Dr. Markus Müller" wrote:
> Dear listers,
>
> I am trying to get shapefiles in and out of a mySQL database using OGR.
> I found some example commands for importing and succeeded in doing this.
> But getting the syntax together to get a spatial dataset out of mySQL db
> seems to be over my head.
>
> Can anybody supply an example command to convert from mySQL to shape? Or
> is it just not possible to export geodata from mySQL into shapefiles
> using OGR?

The MapServer project includes some good examples of using the ogrinfo 
utility on mySQL databases: 
http://www.mapserver.org/input/vector/mysql.html#test-connection-with-ogrinfo 


I would start there, then execute the commands that Frank mentions.

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/