020221 13:12:19 mysqld started 020221 13:12:20 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020221 13:12:20 mysqld ended
also it would be important to note /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/tmcdbs01.mysql.pid ahh could be a permission problem, the directories require an executable tag correct? drw-rw---- 2 mysql mysql 512 Jan 18 18:51 mysql -rw-rw---- 1 mysql mysql 0 Jan 18 18:45 host.MYD -rw-rw---- 1 mysql mysql 1024 Jan 18 18:45 host.MYI -rw-rw---- 1 mysql mysql 8958 Jan 18 18:45 host.frm -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 1:46 PM To: Luc Foisy Cc: MYSQL-List (E-mail) Subject: Re: Problems finding parts of mysql on FreeBSD In the last episode (Feb 21), Luc Foisy said: > Ok. I do indeed have /usr/local/etc/rc.d/mysql-server.sh > And oops I do have /usr/local/libexec/mysqld > > Are these supposed to be started up automatically? > > I tried to run /usr/local/etc/rc.d/mysql-server.sh start > TMCBSD101# mysql-server.sh start > mysql-server.sh: Command not found. > TMCBSD101# ./mysql-server.sh start > TMCBSD101# ps -ax > TMCBSD101# mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (61) Take a look at /var/db/mysql/<hostname>.log and <hostname>.err; it looks like mysql might have exited immediately after it was started. > /usr/local/bin/safe_mysqld & -user=mysql > /dev/null > > will load the mysql server. So why is this not performed at start up? > > And if this script is used, what is mysqld used for?? safe_mysqld calls mysqld and loops so that if mysqld died unexpectedly it is restarted. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php