Skip over navigation

Please note that you're viewing an, older archived version of this page. You probably found it through Google, an older link, or post. Please visit our home page for the current site.

Blog: Switch2Mac

Spotlight saved me

01 May 05 by DL Byron

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.

filed under: Switch2Mac | Link Cosmos | View Comments (2) | post your comment (closed)

Comments

Posted by Jon Lane | 02 May 05

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

Posted by -b- | 02 May 05

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

Note: comments are closed. If you'd like to comment on this post, please contact us.