Textura Design is a creative force specializing in business blogging for clients big and small.

Textura Design Blog

Spotlight saved me

posted by DL Byron on May 01, 2005

Spotlight After upgrading OS X to Tiger (I used the Archive and Install method) I started restoring my Localhost server (Websharing) and absolutely could not remember how I got MySQL running with MovableType locally. I googled it, looked all over for it, and finally typed "MySQL" into Spotlight. The directions were in an iChat I had with Doug in March and Spotlight found it. 10 minutes later, I was up and running. Spotlight saved me hours of work.

After that, I realized that I don't care where my data is, as long as an application finds it for me. Spotlight finds data as quickly as I type.

Underneath that beautiful interface, OSX is a 'nix box and that means I run my blogs locally on my Powerbook for testing, development, client demos, and lectures.

Resources

For more on using localhost, Movable Type and MySQL with OSX check

And Walt Mossberg's review of OS X and Spotlight.

Comments (2)
other posts tagged:


Comments

May 02  |  Jon Lane said:

Can you post part of that iChat about getting MT/mySQL working? The link off of the article on “Installing MT on OSX” to “Using MT and mySQL on OS X” seems to be down. There’s some messed up Perl library that I can never get to install. I once fluked out, and got it all running, but I haven’t been able to figure it out since.

-Jon

May 02  |  -b- said:

Sure, but also check the new article from the MacZealots on SQLite.

After installing MT, setting permissions, and the config, I downloaded and installed mySQL. Then:

  • cd /usr/local/mysql
  • sudo chown -R mysql data/
  • (password prompt) hit enter
  • sudo echo
  • sudo ./bin/mysqld_safe&
  • mysql>
  • mysql> show databases;
  • /usr/local/mysql/bin/mysql -u root -p
  • (password prompt) hit enter
  • CREATE DATABASE pugblog;
  • use pugblog;
  • /usr/local/mysql/bin/mysqladmin -u root password puglove

Then, in mt.cfg

ObjectDriver DBI::mysql
Database pugblog
DBUser root

Note that I don’t really know WTF I’m doing with mySQL and Doug helped me in iChat. Good luck and note that that with MT 3.16, I got HTML template errors and had to update to the latest and then I was good to go


Post your comment