Re: MySQL Under Mac OS X (v3)

Below is a recipe for getting the current version of MySQL running under
MacOS X 10.3.3.

I am still interested in other people's experiences and clues with MySQL,
PostgreSQL, or other production-quality free DBs.

I am wondering if it would make more sense to compile the MyOBDC
driver from mysql.com, but I don't know how to set the configuration
switches etc for MacOSX. Compilation does not look straight forward
as some additional libraries are required.

--------------

UNIX-level installations

	MySQL 4.0.18 was installed from:

		http://www.mysql.com/downloads/index.html

	MyODBC 3.51.06 was installed by running the driver installer from:

		http://www.serverlogistics.com/mysql.php

	ODBC Administrator was used to configure the drivers and DSN following
	instructions in steps 4-9 in:

		http://members.aol.com/_ht_a/bergert/osx/tip09.htm

	Test with the mysql client to see that the database works.

	Test with odbctest to see that ODBC works.

	CocoaMySQL provides a useful if incomplete GUI interface to MySQL

		http://cocoamysql.sourceforge.net/

	Common SQL requires mysql to run in ANSI mode

		- Select correct configuration file in /usr/local/mysql/support-files/

		- sudo cp /usr/local/mysql/support-files/my-xxx.cnf /usr/local/mysql/data/my.cnf

		- add the line "ansi" after "socket = /tmp/mysql.sock"

		- sudo /usr/local/mysql/bin/mysqladmin shutdown

		- sudo /usr/local/mysql/bin/safe_mysqld --user=root &


LispWorks Initializations

     (progn
	(require "odbc")
	(setf sql:*default-database-type* :odbc)
	(sql:initialize-database-type :database-type :odbc)
	(setq sql:*sql-loading-verbose* t))

There are two private patches needed from Xanalys to handle a
bug in the obdc driver and tinyints.

 (sql:connect "mysql/root/pw" :database-type :odbc)

There may be some additional bugs lurking.