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 > [email protected] > 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. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
