MySQL Bugs: #15862: Dump of spatial data in WKT format

Bug #15862	Dump of spatial data in WKT format
Submitted:	19 Dec 2005 16:46	Modified:	15 Dec 2010 11:53
Reporter:	Giuseppe Maxia	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	5.0.16-max	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any
Tags:	mysqldump

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Spatial data can be imported in MySQL from WKT, and it can also been exported using the astext() and SRID() functions. However, mysqldump doe not have any facility to export such data in WTK format, so that a dump can be performed only through a customized program in an external language (C, Perl, etc).

How to repeat:
Just try to dump a table containing GIS data. 
mysqldump  oprions, such as "--hex-blob" or "--compatible" don't affect spatial data.

Suggested fix:
See a workaround in my blog:
http://datacharmer.blogspot.com/2005/12/dumping-gis-data.html

In addition to dumping in WKT it would be nice if dumping as GeoJSON would be supported.