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

[Stephen Marquard]

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.

###