Documentation - Additions on MySQL

Hi all, Jean-Francois, Thomas,

I gave it a try and added a section on upgrading the MySQL defalt driver
to the documentation. I wrote it because we stumbled upon some hazle with
the driver when upgrading our MySQL database to 5.05x. I think the section
is almost complete, but it lacks the information where to copy the
downloaded driver .jar files to include them in the build process.

@Jean-Francois: Where would I put something like "Troubleshooting Hints"?
As I mentioned when we upgraded our MySQL we made some experiences that I
would like to share with others ;-).
For instance the MySQL guys decided in 5.0.51 that InnoDB would be a good
choice for a default database engine. Older versions used MyISAM as a
default engine. When you do a dump of a 4.0.x MyISAM database MySQL will
happily write "Engine" directives to your dump files. This leads to MyISAM
tables in a default InnoDB MySQL datbase after importing the dump. That's
fine, unless you are going to upgrade Scarab as well. The problem is that
the Scarab table creation scripts do not contain any "Engine" directives
and thus will create InnoDB tables in a 5.0.51 MySQL. InnoDB in turn does
support foreign key constraints. So the uprade of Scarab fails when MySQL
attempts to enforce the FKs from an InnoDB to a MyISAM table. I just don't
remember the exact error message, I will post it when I had a look into my
files. Solution was in that case to add MyISAM "Engine" directives to the
Scarab table creation scripts.

So after I did already post a description on what our problem was a and
what we did to fix it you will probably find a place where to put that
text :-)

@Thomas: Thanks for your hint regarding XMLMind, it was quite useful with
editing the DocBook files. You have to get accustomed to it, but it does a
good job.

cheers
Torsten

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]