Infrastructure Map Server General

Reply
Member
Posts: 3
Registered: ‎11-26-2009
Message 1 of 3 (151 Views)

What is the point of mysql database

151 Views, 2 Replies
12-22-2009 05:02 AM
Hi
I am not sure how mysql database is to be used in Autodesk MapGuide Enterprise 2010. I have installed:
  1. Mapguide server on win server 2008 (using apache and php)
  2. Mysql Server 5.0.67
  3. Autodesk Mapguide Studio 2010
All on the same machine. I have managed to connect to a sample database via Autodesk Mapguide Studio 2010. How do i create layers generally, and what exactly is the use of mysql database here? If anybody knows any links or references, please forward them to me.

Thank you
Valued Contributor
Posts: 51
Registered: ‎01-03-2007
Message 2 of 3 (151 Views)

Re: What is the point of mysql database

12-22-2009 10:46 AM in reply to: GeorgeGeorgiou3505
You don't _need_ mysql to run mapguide (it uses a filesystem based repository). However mapguide can digest MySQL as a datasource to display maps.

In order to display a map you will need.

- Datasource (this can be SDFs, SHPs, connections to database, etc)
- Layer (consumes the datasource and styles the information)
- Map (contains the layers you want to display)
- Layout (contains the information for the interface around the map and what maps to display)
(technically you don't need a layout if you don't bother with the included viewers)

In order for mapguide to work with MySQL you will need tables with:

- A primary key (this is used for the selection)
- A Geometry Column (I think there are geom, point, line, polygon, etc). Also you will want to build an index on this (I think it uses rtree by default).

You can also make an FDO schema from within map or civil or other tools. This defines the tables, coordinate systems, keys, etc. It is a bit more flexible the just making a table in an empty database but requires more configuration/maintenance.

Once you have that it _should_ show up in the layer on the drop down below the datasource. (Just note we haven't used mysql for awhile. So I might be wrong on some things).
Member
Posts: 3
Registered: ‎11-26-2009
Message 3 of 3 (151 Views)

Re: What is the point of mysql database

01-05-2010 12:45 AM in reply to: GeorgeGeorgiou3505
Thank you sakkaku. This information sure will be useful.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community