Start the eSuite4X Setup Assistant

Follow the on screen instructions provided by the eSuite4X Setup Assistant. The default settings install MySQL4, Apache 2 and all needed additional applications and starts up the MySQL4 and Apache 2 database server.

Stop your existing MySQL database server

It is not possible to start two MySQL database servers with standard settings at the same time on the same machine. This means the eSuite4X Setup Assistant will fail to start the new MySQL4 database server if an older release is still running.

Stop your existing MySQL database server following the guidelines of your current MySQL distribution. You can check that your MySQL server is stoppen with the Mac OS X Process Viewer (/Applications/Utilities/Process Viewer.app). Look for an application "mysqld". If you can find mysqld in the process list your database server is still active.

Back up your current databases

MySQL stores databases in a special directory. The location of this directory depends on your MySQL distribution. eSuite4X 1.x and 2.x store MySQL databases in /Library/eSuite4X/MySQL3/Databases. Another commonly used location is /usr/local/mysql/data or /usr/local/mysql/var.

Copy all folders from the database directory to your backup location (actually each folder is a MySQL database and usually for each table exist 3 files). You can use Mac OS X Finder to copy your databases.

Start the eSuite4X Setup Assistant

Follow the on screen instructions provided by the eSuite4X Setup Assistant. The default settings install MySQL4 and all needed additional applications and starts up the MySQL4 database server.

Restore your Databases

To bring your saved databases back online with the new MySQL release copy all folder from your backup except the folder mysql to /Library/eSuite4X/MySQL4/Databases/.

Optional: Convert your MySQL system database

The mysql folder from your backup contains your old user database and all access privileges. This database has been changed and you must convert older version to use them with MySQL4. Currently you have to do the conversion with a command line interface, but we are working on a graphical interface which will be available on our web site soon.

To use your old MySQL system database stop your MySQL4 server with the Mac OS X System Preferences -> eSuite4X -> Server pane. Then copy the mysql folder from your backup to /Library/eSuite4X/MySQL4/Databases/ (and replace the mysql folder created by the eSuite4X Setup Assistant). Now open /Applications/Utilities/Terminal.app and enter the following commands:

   cd /Library/eSuite4X/MySQL4

   ./bin/mysql_fix_privilege_tables

Now you can restart your MySQL4 database server with the Mac OS X System Preferences -> eSuite4X -> Server pane.