Setting up MovableType with MySQL on Server

Nov 16, '03 12:56:00AM

Contributed by: Anonymous

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:

  1. 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)
  2. Install the downloadable MySQL install from the mysql.com download page (detailed install instructions can be found at the excellent Entropy site).
  3. Go to the new directory (/usr/local/mysql) and move the data subdirectory to one side (mv data data.standard)
  4. Extract the backup and rename it (tar xvpf /tmp/mysql-data.tar; mv mysql data).
  5. Install the startup script (part of the MySQL distribution) and start restoring your MovableType data.
The main reason that the two versions can be installed stems from the fact that the startup scripts use different flags in /etc/hostconfig. The Apple version uses MYSQL which will be set to -NO- by the MySQL installer. The MySQL version uses MYSQLCOM which will be set to -YES-.

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.

Comments (2)


Mac OS X Hints
http://hints.macworld.com/article.php?story=20031106225307752