[MAS-tips] Re: MAS Software - MySQL DB

[Jim C. <jt...@di...>]

Hi Oscar.

> Hi,
> 
> I have recently installed and tested MAS on Linux RedHat 7.3
> using flat text files as DB.
> 
> I wish to switch to using MySQL as DB. So far I have a working
> MySQL and unixODBC. I am setting up the DB for MAS and
> from the sysadmin docs it is mentioned that there are Postgress
> scripts for doing so. However, I have looked and looked in the
> files but have not found them.=20
> 
> Is there any chance that I can have a copy of these scripts ?

Yes.  Several people have asked me this question.  When I read your email,
I realized it was time for me to put it in the FAQ.  Here's the answer,
copied from the FAQ
(http://eiffel-mas.sourceforge.net/support/FAQ.html#database):

The example script files for creating MAS tables reside in a file separate
from the main MAS installation file. You will find them in the scripts
archive file in the download section - either scripts{relnum}.tar.gz or
scripts{relnum}.zip -, where {relnum} stands for the release number -
e.g., 1.6.5. (The scripts files for the latest release, 1.6.5 - as of
June 2003 - are scripts1.6.5.tar.gz and scripts1.6.5.zip.) Several people
have asked me this question, so I've concluded that I need to include
the database scripts with the main installation file. I will probably
do this for the next official (non-beta) release.

[The download URL is:
http://sourceforge.net/project/showfiles.php?group_id=6838]

> When I have successfully completed this exercise is it worth
> that I write a how-to for MySQL and post at subsciption list ?

Definitely!  This would be much appreciated - not only by me, but, I'm
sure, by future MAS users who want to do the same thing.

(I'm also sending this response to the tips and discuss lists.)

> 
> Thanks in advance.
> 
> Oscar Plameras

You're quite welcome.

Jim Cochrane