OS X Client Server

For some reason my postfix mail server kept crashing and would not stay up longer then one day. This got really annoying and made it impossible to use my server for any sites that had any email aspect to them. This week I found a really good way to monitor and keep postfix up and running at all times.

To do this you will need Webmin installed so if you dont already go install it now. Here are the instructions: Install Webmin on OS X

To set up a Postfix monitoring system:

1. Open Webmin

2. Click the “others” tab

(more…)

Today I was backing up my servers mysql database remotely using:

/usr/local/mysql/bin/mysqldump -u username -ppassword –skip-lock-tables –add-drop-table –all-databases > remotebackup.sql

I was using the Command Shell in Webmin

(more…)

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…)