MyGIS without shp2mysql.pl

[Samuele Poletto]

Hi, 
I would like to know if it is possible to use mygis layers without having to convert the data with shp2mysql.pl.
That script creates 3 different tables for each layer, and for my application I need to have only 1 table per layer, having a gid and the geometric field...
However, if I try to configure my layer in the map file in this way:
CONNECTION       "host:user:password:dbname:bin:"
CONNECTIONTYPE   mygis
DATA             "the_geom from table53"

where table53 is like this:
gid   	bigint(20)
the_geom   	blob (stored in WKB format)

mapserver crashes without any error message.

thanks for you help...

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071212/41c28b1d/attachment.htm>