[Gdal-dev] Readonly MySQL Support

[Frank Warmerdam]

Folks,

I have implemented read-only support for non-spatial MySQL databases using
the mysql C API.  This is pretty easy to build in and use on Unix/Linux
(--with-mysql=.../mysql_config).  On Windows it is somewhat tricker since
you seem to need to build with /MT /GX in order to use the libraries provided
with MySQL 4.1.

Use a datasource name something like:

   MYSQL:dbname,user=warmerda,password=fancypass,host=home.gdal.org,port=3603

All the stuff from user= on can be ignored, or set in your .my.cnf configuration
file.

If anyone has questions read over the driver docs and then feel free to ask
questions.

Note that I do not currently support the new MySQL spatial objects, though that
is quite desirable.  I also do not support writing to MySQL at this time though
I would like to implement that at some point as well.

This work was mostly done to avoid the hassles of ODBC configuration on Linux
for the fairly common use of non-spatial MySQL data, or MySQL data in which
the spatial relationship is established via a .vrt file.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent