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
