mysqld_safe does not end after start of mysqld

[Uzi Klein]

Roger Grosswiler wrote:
> hi,
> 
> If i launch mysqld_safe, i expect it goes in background, but it doesn't.
> even statring /usr/local/bin/mysqld_safe& just puts out the pid.
> 
> root at freebsd# /usr/local/bin/mysqld_safe&
> [1] 5433
> root at freebsd# Starting mysqld daemon with databases from /var/db/mysql
better use the rc script
/usr/local/etc/rc.d/mysql-server.sh (start|stop|...)

after adding the mysql vars into /etc/rc.conf:
mysql_enable="YES"
mysql_limits="YES" # (optional)
( see all in the rc script)

I have found that the pidfile variable in mysql-server.sh doesnt act as 
expected when you use the stop command.
commenting that line solved the problem for me;

#pidfile="${mysql_dbdir}/`/bin/hostname`.pid"

> 
> ...and that's all. usually, i expect it goes in background and i could
> close that shell. did i miss something? it's just a fresh install from
> ports, initing with mysql_install_db and mysql_create_system_tables.
> 
> Thanks for any help
> Roger
> 
> _______________________________________________
> freebsd-stable at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"
> 


-- 
Uzi Klein
Software Development Executive
B.M.B.Y Software Systems LTD.
http://www.bmby.com