Changes between Version 1 and Version 2 of MySQL


Ignore:
Timestamp:
Jan 28, 2009, 1:02:22 PM (15 years ago)
Author:
jmckenna
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • MySQL

    v1 v2  
    22
    33----
    4 The official MySQL with MapServer doc lives at: http://www.mapserver.org/input/vector/mysql.html
     4The official MySQL with !MapServer doc lives at: http://www.mapserver.org/input/vector/mysql.html
    55----
    66
    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 (AttilaCsipa).
     7This 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).
    88
    99Using 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
    … …  
    2121== Converting SHP data into MySQL based OpenGIS SFSQL ==
    2222
    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 type
     23The 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
    2424{{{
    2525 shp2mysql.pl /path/to/shp/file/my_shape_file
    … …  
    8080=== How does this work ? ===
    8181
    82 Through a dedicated MapServer module written in C.
     82Through a dedicated !MapServer module written in C.
    8383
    8484=== How do I use it ? ===