Install MySQL Help Tables

[Randy_Chrismon/FDS]

I'm confused... The 4.1 alpha features says that MySQL now has help files 
installed with the server. I did a clean install (Win2K), following all 
directions to the best of my ability, and find no help files. I did 
discover a SQL file that purported to fill the help files: 
fill_help_tables.sql. All they seem to do, however, is create empty 
tables. What am I missing? It's not critical, of course, I seem to find 
most of the help I need either in the documentation or on the internet. 
But it would be nice to have the server based help when I just need a 
quick reminder of parameters or the exact name of a function or whatever. 

Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight 
install (rpm -Uvh) failed on a bunch of dependencies -- including the fact 
that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on 
the existing installation, tried again on the new distributions and got 
failed dependencies for libcrypto 0.9.6 and libssl (don't remember the 
version number). The Redhat 9 installation has libcrypto 0.9.7a, so I'm 
not sure why the dependency check fails. I whent ahead with a --nodeps 
install and the basic server seems to run alright. However, when I then 
tried to install -Max, the service wouldn't start. I haven't pursued that 
problem -- simply went back to the basic server install. Actually, I had 
to do a complete reinstall of the server to get it to work. One question: 
do I need Max to get the transaction type capabilities for committing, 
roll back, etc? The documentation seems to imply yes in some places and no 
in others. Is the InnoDB in MySQL-server, enough to get these 
capabilities?

Thanks.

Randy

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Won't Shut Down

[Randy_Chrismon/FDS]

After installing MySQL 4.1 on a Win2K machine, I tried to run the 
mysql_fix_privilege_tables.sql script. I got the duplicate column name 
errors which the documentation says I can safely ignore. However, I also 
got this error:

ERROR 1064 at line 67: You have an error in your SQL syntax.  Check the 
manual that corresponds to your MySQL server version for the right syntax 
to use near 'func ADD type enum ('function','aggregate') NOT NULL' at line 
1
@hadShowDbPriv:=1

Documentation didn't say nuthin' about no 1064 error. (Wonder if it's 
related to William the Conqueror?) Also, on a couple of occasions, I've 
tried to shut the MySQL process down, either from the gui or using net 
stop mysql and I get error messages that the server is not responding to 
the shutdown message, a time out or some other error. I have to re-boot to 
shutdown the MySQL server process (I have the process set to start 
manually -- usually using net start mysql. This is just a 
test/develoment environment. The latest error message was: 

The service could not be controlled in its present state.

More help is available by typing NET HELPMSG 2189.

Although, in this case, this came after I aborted (ctl-C) net stop mysql 
and it filled up half the screen with dots while waiting for the shutdown. 
Interestingly, in most (all?) cases, the mysql.err log says MySQL shut 
down successfully even though it still shows as a process in the Win2K 
Task List, and can't be restarted without a reboot. 

What's going on here?

Thanks.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]