RESOLUTION: mysqld works but not mysqld_safe

2007-07-20 Thread Chris Africa
1. Get rid of the offending $hostname.index file that keeps track of binlogs (Thanks, Olaf!). 2. Fix permissions (Thanks, Gerald Clark!). Have a nice day! Chris On Jul 18, 2007, at 2:19 PM, Olaf Stein wrote: You have bin log enabled and it might be looking for the last bin log

mysqld works but not mysqld_safe

2007-07-18 Thread Chris Africa
Hi Everyone. I had a perfectly good working version of MySQL and then I decided to try something new... Now, I can start up as root with mysqld, but when I start with mysqld_safe as I always have in the past, mysqld quits immediately. Here's the saga: I decided to use phpmyadmin to

Re: mysqld works but not mysqld_safe

2007-07-18 Thread Gerald L. Clark
Chris Africa wrote: - 070717 22:44:12 mysqld started 070717 22:44:12 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 070717 22:44:12 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used;

Re: mysqld works but not mysqld_safe

2007-07-18 Thread Chris Africa
Hi Gerald. Actually, mysql should have access, as it owns the entire directory. drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4- i686 and nested inside that is drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data Thanks! -- Chris Africa Web Project Manager

Re: mysqld works but not mysqld_safe

2007-07-18 Thread Olaf Stein
You have bin log enabled and it might be looking for the last bin log before the last shutdown ('/usr/local/mysql-5.0.41-osx10.4-i686/data/me-web2-bin.27') You can either: - move the missing binlog file where mysql is looking for it - delete the $hostname.index file that keeps track of

Re: mysqld works but not mysqld_safe

2007-07-18 Thread Gerald L. Clark
Chris Africa wrote: Hi Gerald. Actually, mysql should have access, as it owns the entire directory. drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4- i686 and nested inside that is drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data Thanks! Error 13 is a