[Building Sakai] Startup mysql issues on MacOS 10.6.4, mysql 5.1.48

[Matthew Jones]

FYI: From the mysql manual, the value of 0 is not recommended for osx. [1]
Though I guess this would depend on if you have your database files on a UFS
(case sensitive) or HFS+ (case insensitive) volume though? Though probably
not many people know the file-system for their mac installation.

The value of "1" usually seems to be the best way to go overall and is what
we have been recommending in the Sakai Admin guide. [2] Might want to revise
this if it needs some clarification. I have been running my dev Sakai DB's
off of Windows Server 2008.

This issue and the "default-storage-engine=InnoDB" come up as pretty common
problems. :(

>From the manual:

> Value 0: " Name comparisons are case sensitive. You should not set this
> variable to 0 if you are running MySQL on a system that has case-insensitive
> file names (such as Windows or Mac OS X). "


> "On Unix, the default value of lower_case_table_names is 0. On Windows the
> default value is 1. On Mac OS X, the default value is 2."


[1] http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
[2]
http://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning
<http://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning>
On Tue, Jun 29, 2010 at 7:32 AM, Stephen Marquard <
stephen.marquard at uct.ac.za> wrote:

> Hi all
>
> After upgrading my Macbook to Snow Leopard and reinstalling mysql to the
> latest 5.1.48 download for MacOS, I ran into startup problems with DDL
> errors (e.g. 'multiple primary key defined' trying to create or update
> tables).
>
> I found a way to fix this, which is to specify in
> /usr/local/mysql/etc/my.cnf:
>
> [mysqld]
> set-variable=lower_case_table_names=0
>
> (and stop and start mysql, drop and recreate the sakai db).
>
> Hope this helps someone.
>
> Cheers
> Stephen
>
>
>
>
>
> ###
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from
> +27 21 650 4500. This e-mail is intended only for the person(s) to whom it
> is addressed. If the e-mail has reached you in error, please notify the
> author. If you are not the intended recipient of the e-mail you may not use,
> disclose, copy, redirect or print the content. If this e-mail is not related
> to the business of UCT it is sent by the sender in the sender's individual
> capacity.
>
> ###
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100629/1fc10ede/attachment.html