Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Setting up MovableType with MySQL on Server OS X Server
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 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.
  • Currently 1.38 / 5
  You rated: 2 / 5 (8 votes cast)

Setting up MovableType with MySQL on Server | 2 comments | Create New Account
Click here to return to the 'Setting up MovableType with MySQL on Server' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Setting up MovableType with MySQL on Server
Authored by: nutbeem on Nov 16, '03 06:45:27PM

And this means what in english?

[ Reply to This | # ]
Setting up MovableType with MySQL on Server
Authored by: jpmvdr on Dec 03, '03 07:29:18PM

The Panther server does not deal correctly with date fields. This is not corrected by the MySQL 4.0.16 version that is included in the (not yet released) Server 10.3.2. This is not an issue with the non-server version of Panther.

I even tried to shut down the database running on our Jaguar Server, zip the files and move them to the Panther server. Unzipped, fixed permissions on the files and brought up the database... The date data was not a pretty sight...

[ Reply to This | # ]