OS X Client Server

MYSQL is an amazing tool but when something goes wrong it can be a real disaster. Maintaining a good back up and recovery plan is an extremely wise step.

In OS X it is very easy to back up your MYSQL databases.

Open a Terminal window (Applications -> Utilities - > Terminal)

Change “DatabaseName” to the name of the database you want to back up and type:

/usr/local/mysql/bin/mysqldump -u root -p DatabaseName > backup.sql

or

mysqldump -u root -p DatabaseName > backup.sql
(more…)

My First OS X Web Server tip is also my favorite. Have you ever wanted watch your web traffic in real time? It turns out its not all that hard.

*** Caution this tip is highly addictive.

Open a Terminal window (Applications -> Utilities - > Terminal)

Type:
(more…)

We will provide articles and tips about OS X Web Servers, PHP, MYSQL and other OS X webmaster information. Whats with the name? We are running OS X as a server but not running OS X server. This site is about running a web server from the standard OS X Client version that comes with every new mac. Luckily for us all versions of OS X come with a built in very powerful Apache web server pre installed. Stay tuned for complete guides on how to set up your own webserver.