Changes between Version 1 and Version 2 of MySQL
- Timestamp:
- Jan 28, 2009, 1:02:22 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
MySQL
v1 v2 2 2 3 3 ---- 4 The official MySQL with MapServer doc lives at: http://www.mapserver.org/input/vector/mysql.html4 The official MySQL with !MapServer doc lives at: http://www.mapserver.org/input/vector/mysql.html 5 5 ---- 6 6 7 This page should provide information about using data sources from a non-spatially enabled MySQL server. It should work with both 3.x and 4.x versions of MySQL. If you have any questions or suggestions, contact the author (Attila Csipa).7 This page should provide information about using data sources from a non-spatially enabled MySQL server. It should work with both 3.x and 4.x versions of MySQL. If you have any questions or suggestions, contact the author (Attila Csipa). 8 8 9 9 Using a mysql data source means that BOTH spatial and feature data are stored in mysql tables. If you want shapefiles (.SHP) for spatial data and mysql for feature data (usually stored in the .DBF files), you might want to take a look at JoinDatasources … … 21 21 == Converting SHP data into MySQL based OpenGIS SFSQL == 22 22 23 The easiest way to do this is to use the shp2mysql.pl perl script supplied with MapServer (if you do not have it, chances are that you are not using a recent and complete version). To use this conversion script you MUST install the perl binding for shapelib (http://www.water.hut.fi/pub/Grid/Shape-0.04.tar.gz). First, you have to edit the database access parameters in the shp2mysql file itself. After that, simply type23 The easiest way to do this is to use the shp2mysql.pl perl script supplied with !MapServer (if you do not have it, chances are that you are not using a recent and complete version). To use this conversion script you MUST install the perl binding for shapelib (http://www.water.hut.fi/pub/Grid/Shape-0.04.tar.gz). First, you have to edit the database access parameters in the shp2mysql file itself. After that, simply type 24 24 {{{ 25 25 shp2mysql.pl /path/to/shp/file/my_shape_file … … 80 80 === How does this work ? === 81 81 82 Through a dedicated MapServer module written in C.82 Through a dedicated !MapServer module written in C. 83 83 84 84 === How do I use it ? ===