Mapserver and MySQL

[Roger Boily]

Vishal,
we use mySql since a couple of years with mapserver  and it works
perfectly with OGR.
You have to compile ogr with mySql, so you'll have the MySQL format
activated.
First, compile mysql from source (or install the install the dev
libraries: [debian : "apt-get install libmysqlclient15-dev"])
Then compile ogr with mysql: ./configure --with-mysql=/usr/bin/mysql_config
You're done.
in the mapfile add :
    CONNECTIONTYPE OGR
    CONNECTION "MySQL:dataBaseName,user=userName,password=yourPass,
GeomTableName"
    DATA "SELECT * FROM GeomTableName"

hope it helps,
Roger Boily

Vishal Nagpal ha scritto:
> Hi,
> Thanx a lot, for quick response,
> Yes I did install from the source,
> The ogrinfo --formats does not display MySQL
> Neither did I find any option of installing --with MySQL 
>
> So do I install GDAL/OGR and Mapserver again ????
>
> Yes I understand use of ovf file with x and y coord but I think my problem
> is the support of OGR for MySQL. 
>
> Actually I have my application in MySQL and it will be difficult to shift
> over to PostgreSQL at this stage. So I wish to use MySQL.
> Thanks and Regards
> Vishal
>