[mapserver-users] how can I associate MySql and Gdal

[karlos036]

Murat,

  You'll need to get the MapServer source and compile it yourself in order
to add MySql support.

  Look at the 5.4.2 documentation
(http://mapserver.org/installation/unix.html) for instructions.

  In order to compile MapServer, you'll need to have the MySql db, client
and dev packages installed.  You can use whatever package manager you have
to add any missing component.

  I've did some testing with MySql.  I converted all of the world country
shapefiles (.shp) to sql import scripts and then imported them into MySql (I
have instructions on how to do this archived somewhere).  Displaying simple
geometries worked OK, but complex shapes such as Argentina or Chile (lots of
small vectors define the country outline) were very slow to load even when
indexed carefully.  I found that PostgesSQL was much faster and better
supported if you are planning on storing your shapefiles within a database
in order to query and then display them.   If you are just storing data
points, then MySql works fine.

Cheers,

Karlos

Murat Beyhan wrote:
> 
> Hi friends,
> 
> I have installed mandriva 2010 and then
> installed Mysql mapserver and gdal which are coming with Mandriva one CD.
> But I could not read data from MySql database by using ogr because of the
> supported formats.
> How could I associate MySql with gdal in order to draw map using data
> stored
> in MySql
> Please help me
> the formats supported by gdal as follows
> murat
> 
> ogrinfo --formats
> Supported Formats:
>   -> "GRASS" (readonly)
>   -> "ESRI Shapefile" (read/write)
>   -> "MapInfo File" (read/write)
>   -> "UK .NTF" (readonly)
>   -> "SDTS" (readonly)
>   -> "TIGER" (read/write)
>   -> "S57" (read/write)
>   -> "DGN" (read/write)
>   -> "VRT" (readonly)
>   -> "REC" (readonly)
>   -> "Memory" (read/write)
>   -> "BNA" (read/write)
>   -> "CSV" (read/write)
>   -> "GML" (read/write)
>   -> "GPX" (read/write)
>   -> "KML" (read/write)
>   -> "GeoJSON" (read/write)
>   -> "GMT" (read/write)
>   -> "SQLite" (read/write)
>   -> "ODBC" (read/write)
>   -> "PGeo" (readonly)
>   -> "OGDI" (readonly)
>   -> "PostgreSQL" (read/write)
>   -> "XPlane" (readonly)
>   -> "AVCBin" (readonly)
>   -> "AVCE00" (readonly)
>   -> "Geoconcept" (read/write)
> 
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/how-can-I-associate-MySql-and-Gdal-tp4385959p4392920.html
Sent from the Mapserver - User mailing list archive at Nabble.com.