MailSteward Pro™

Contents:

Links:

MailSteward

Installing MySQL©:

To install MySQL database server software on a Mac running OS X 10.4 or higher, first go to the MySQL.com download site, and download the appropriate package format dmg file. Then open the .dmg file and double-click on the .pkg file, as you would with any Mac software package. The ReadMe.txt file has detailed instructions.

There is also a System Preferences panel called "MySQL.prefPane". Double-click on this and it will install itself in the System Preferences. You can then use it to stop and start the MySQL server.

You should also set the root password for MySQL. Open a terminal window, and type the following two statements on the command line.

cd /usr/local/mysql/bin
./mysqladmin -u root password 'new-password'

where "new-password" is your chosen MySQL root password. Note that this has nothing to do with your computer's "root" password. It is entirely separate. This is not your system root. It is just the MySQL root.

In order to archive email containing large attachments into MySQL, the MySQL maximum allowed packet size needs to be set large enough to accommodate the attachment blobs. This can be done by adding two lines to the MySQL configuration file located at /etc/my.cnf. In order to edit this file, you will need to be the OS X root user. The procedure for enabling the root user on OS X is explained at http://support.apple.com/kb/HT1528. Once the system root user has been enabled, open a terminal window and do the following on the command line:

su

Then you will be asked for the system root user password:

Password: [enter your password here]
cd /etc
cat>my.cnf
[mysqld]
max_allowed_packet=200M

Then type control-d to quit editing the file, and then type "exit" to quit being the root user, and then restart the MySQL server. You can restart the MySQL server by going to System Preferences and clicking on the MySQL preference pane that you installed previously.

You can set max_allowed_packet size as large as you like. MySQL will only allocate the extra memory when it is needed.

There is an excellent open source Mac Cocoa MySQL management program called CocoaMySQL, which can be obtained here. You can use this software to view and edit any MySQL database, including a MailSteward MySQL database. If you use it, send the developer a donation.