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; so replication may break when this MySQL
> server acts as a master and has his hostname changed!! Please use
> '--log-bin=/usr/local/mysql/data/me-web2-bin' to avoid this problem.
> 070717 22:44:12 InnoDB: Started; log sequence number 0 335107
> /usr/local/mysql/bin/mysqld: File '/usr/local/mysql-5.0.41-osx10.4-
> i686/data/me-web2-bin.000027' not found (Errcode: 13)
> 070717 22:44:12 [ERROR] Failed to open log (file '/usr/local/
> mysql-5.0.41-osx10.4-i686/data/me-web2-bin.000027', errno 13)
> 070717 22:44:12 [ERROR] Could not open log file
> 070717 22:44:12 [ERROR] Can't init tc log
> 070717 22:44:12 [ERROR] Aborting
> 070717 22:44:12 InnoDB: Starting shutdown...
> 070717 22:44:14 InnoDB: Shutdown completed; log sequence number 0 335107
> 070717 22:44:14 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
> 070717 22:44:15 mysqld ended
> -------------
>
> I'm not using replication, but I am using mirrored drives, and this is
> the first time I've ever done that. Still, it didn't seem to be a
> problem until I screwed up the passwords.
>
> I'm just setting up a new server, so the tables and data are not dear
> to me. Right now, I just want MySQL to work -- with logging!!
>
> --
> Chris Africa
> Web Project Manager
> Department of Mechanical Engineering
> University of Michigan
> 734-764-8482
> Fridays: 734-355-6577
> AIM/iChat/Skype ID: baiewola
>
>
mysql does not have write privilege in
/usr/local/mysql-5.0.41-osx10.4-i686/data.
Is this owned by root too?

--
Gerald L. Clark
Supplier Systems Corporation