Status: offline

dreness

Forum User
Newbie
Registered: 06/08/03
Posts: 11
Quote by Dirk:
Quote by heidialyssa: Has anyone discovered a fix for this?

Well, apparently you have 2 options:
  1. Install the MySQL binary from mysql.com
  2. Yell at Apple to fix it

bye, Dirk


I installed the binary from mysql.com, and it does appear to sort messages properly, with one BIG caveat: all stories seemed to have lost their date stamp. In my case, not a big deal since I don't have a lot; I just manually re-dated them all, and now they sort properly.

The basic process for installing the binary went about like this:

1) Download the binary release and unzip / untar it, then move the resulting directory to /usr/local.

2) Follow the installation steps in the INSTALL-BINARY file for creating a symbolic link to /usr/local/mysql from the mysql directory, e.g.
PHP Formatted Code
ln -s /usr/local/mysql-standard-4.0.17-apple-darwin6.8-powerpc
/usr/local/mysql
 
and also follow the 'chown' steps.

3) Rename /usr/local/mysql/data to data.new or something, then symlink from /var/mysql (which is where the existing databases live) to /usr/local/mysql/data as follows:
PHP Formatted Code
ln -s /var/mysql /usr/local/mysql/data
 


That should be about it. In my case, I had to also revert to a 'stock' geeklog distribution, free of the various hacks I'd attempted to fix this sorting problem, so I just took the opportunity to upgrade to the latest version.

Note that if you're upgrading, you can skip the creation of the mysql user / group, and also skip the install_db (since you'll be using your existing one).

Hope this helps,
-Andre

Status: offline

das

Forum User
Newbie
Registered: 03/01/04
Posts: 11
This issue is now fixed in the Mac OS X Server 10.3.3 update:

http://docs.info.apple.com/article.html?artnum=107851#sql

Mac OS X Server 10.3.3 includes a new binary of MySQL 4.0.18 that fixes the issue that was present in the included MySQL in Mac OS X Server 10.3, 10.3.1, and 10.3.2.

dreness

Anonymous
Quote by das: This issue is now fixed in the Mac OS X Server 10.3.3 update:

http://docs.info.apple.com/article.html?artnum=107851#sql


Though it's mentioned in the document linked above, since some people never read before installing, I will add this:

** Be sure to dump your mysql db before the update, and then load it after **

Page navigation