The
Ultimate
Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog • Archive • Cutedge

by: Bernard Teo








Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

The Ultimate Business Machine - Archives

List of Categories : Database * Technology * Commentary * Singapore * Travel *

Tue 28 Aug 2012

Pref Panes With Port Number Field

Category : Technology/PrefPanesWithPortNo.txt

I've created new Pref Panes for each of the installers that we support—MySQL, PostgreSQL and MariaDB. These versions now include a Port Number field.

MySQLPrefPaneWithPortNo.gif

I built these so that I have a way to run MariaDB and MySQL at the same time (by default, they use the same port, 3306).

And also to figure out how Network Preferences and Sharing Preferences, among others, could have that lock icon at the bottom left hand corner and how to make that work for my own Pref Panes.

I'm now going back to change the way my MariaDB Installer for Mountain Lion works. In its first incarnation, it pretended to be MySQL and, if you have a running MySQL installation, the MariaDB installer will move all the databases you have on MySQL over to MariaDB.

But now, if I'm going to have MariaDB running as a separate database on its own right, the user may not want to mix the MySQL and MariaDB databases. So I'm going to make the MariaDB installer only upgrade a previous MariaDB installation and leave existing MySQL databases alone.

Note : It's actually very easy to copy MySQL databases over to MariaDB. You'll find the databases inside a "data" folder within the MySQL-x.x.x folder, with each database in its own folder (you can recognise them by their database names). Just copy them over to the corresponding "data" folder in the Mariadb-x.x.x main folder.

I'll release them when I'm done changing the MariaDB Installer.

Posted at 5:36AM UTC | permalink

Mac@Work
Put your Mac to Work

• Sivasothi.com? Now how would you do something like that?
• Weblogs. Download and start a weblog of your own.
• A Mac Business Toolbox
A survey of the possibilities
• A Business Scenario
How we could use Macs in businesses
• VPN Enabler for Mavericks
• MailServe for Mavericks
• DNS Enabler for Mavericks
• DNS Agent for Mavericks
• WebMon for Mavericks
• Luca for Mavericks
• Liya for Mountain Lion & Mavericks
• Postfix Enabler for Tiger and Panther
• Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

  • Apache 2 Web Server
  • Postfix Mail Server
  • Dovecot IMAP Server
  • Fetchmail
  • SpamBayes Spam Filter
  • Procmail
  • BIND DNS Server
  • DNS Agent
  • WebDAV Server
  • VPN Server
  • PHP-based weblog
  • MySQL database
  • PostgreSQL database

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.