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

["Dr. Markus Müller"]

Frank and Jeff,

thanks to both of you, that did the trick.


Markus


On 18/01/2011 1:13, Jeff McKenna wrote:
> 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
>
>