mysql won't start on boot

[Vonleigh Simmons]

> What happens if you run "/usr/local/etc/rc.d/mysql-server.sh start"
> manually? Does the log file enlighten you
> (/var/db/mysql/[boxname].err)?

	I think you may have found it. I was able to stop mysql using the rc 
script. However starting it back up did nothing:

# /usr/local/etc/rc.d/mysql-server.sh start
Starting mysql.

	Yet mysql never started up, here is the error log:
---
041208 14:07:26  mysqld started
041208 14:07:26 [ERROR] Can't find messagefile 
'/usr/local/share/mysql/english/errmsg.sys'
041208 14:07:26 [ERROR] Aborting

041208 14:07:26  mysqld ended
---

	I do have the file it's complaining about:

# ll -d /usr/local/share/mysql/english/errmsg.sys
-r--r--r--  1 root  wheel  16568 Dec  6 20:28 
/usr/local/share/mysql/english/err
msg.sys

	If I start it up with mysql_safe using what I think the script is 
using as startup:

# /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql
--pid-file=/var/db/mysql/alpargata.net.pid &

	Then it starts up just fine:
---
041208 14:07:32  mysqld started
041208 14:07:32  InnoDB: Started; log sequence number 0 43912
/usr/local/libexec/mysqld: ready for connections.
Version: '4.1.7'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: 
mysql-server-4.1.7
---

	So I'm really not sure what's going on.


Vonleigh Simmons
<http://illusionart.com/>