[Gdal-dev] Mysql support

[Howard Butler]

Joe,

If you can do a cvs update, there were quite a few changes to the 
mysql driver yesterday and the day before.  These may have an impact 
on your issues.

Also, you can just let ogr2ogr *create* the spatial_ref_sys and 
geometry_columns table for you in a fresh database without manually 
doing it yourself.  Were you just letting ogr2ogr do it, or were you 
doing with some sort of sql command?

Howard

At 12:14 PM 2/17/2006, Miller Joseph wrote:
>Content-class: urn:content-classes:message
>Content-Type: multipart/alternative;
>         boundary="----_=_NextPart_001_01C633ED.EB75D952"
>
>Hey all,
>With some tweaking of ogrmysqllayer.cpp and pcrtypes.h I was able to 
>get the daily build of feb 13 to compile and link on a windows xp 
>system using visual c 6.0.
>
>I used to ogr2ogr to create the Geometry_Columns table and I created 
>a spatial_ref_sys table as described in: 
><http://home.gdal.org/projects/osvecdb/sfsql-schema.html>http://home.gdal.org/projects/osvecdb/sfsql-schema.html
>
>I altered the geometry_columns so that the srid column was a foreign 
>key from the spatial ref table.
>
>I am still not having luck having ogrinfo reflect the srid 
>information I entered.  I even made sure that data I entered using 
>the Geomfromtext function included the srid.  My question is whether 
>I am doing something wrong or if I should wait for a later build to 
>be released before the spatial_ref_sys table is supported??
>
>Thanks in advance,
>Joe Miller
>
>_______________________________________________
>Gdal-dev mailing list
>Gdal-dev at lists.maptools.org
>http://lists.maptools.org/mailman/listinfo/gdal-dev