If you install Panther Server and attempt to set up MovableType with MySQL, it will fail and corrupt some of your data. The problem lies in the datetime fields in the MovableType tables in mysql. To solve this problem:
When Apple releases a patch for the problem, you can reverse the settings in /etc/hostconfig and move the data files from /usr/local/mysql/data back into /var/mysql.
- Archive your existing mysql data (if any) from /var/mysql (I changed to the /var directory and used tar cvpf /tmp/mysql-data.tar ./mysql)
- Install the downloadable MySQL install from the mysql.com download page (detailed install instructions can be found at the excellent Entropy site).
- Go to the new directory (/usr/local/mysql) and move the data subdirectory to one side (mv data data.standard)
- Extract the backup and rename it (tar xvpf /tmp/mysql-data.tar; mv mysql data).
- Install the startup script (part of the MySQL distribution) and start restoring your MovableType data.
When Apple releases a patch for the problem, you can reverse the settings in /etc/hostconfig and move the data files from /usr/local/mysql/data back into /var/mysql.
•
[7,738 views]

