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.
Install eSuite4X - MySQL4 Edition
The eSuite4X distribution includes the eSuite4X Setup Assistant to install MySQL4, the eSuite4X System Preferences pane and some helper applications (like the Log & Config File Manager). You need an administrator password to run the eSuite4X Setup Assistant.
How to install your first MySQL database server
|
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. |
How to upgrade an existing MySQL 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. |
Copy user applications (SQL4X Manager J)
To install the user releated applications copy the folder eSuite4X from the download disk image to your hard disk. You can copy the folder to /Applications to make SQL4X Manager J available to all users working with your computer or any other location. The eSuite4X license is not limited to the number of users, but to the number of machines. If you have one license every user of your computer can use SQL4X Manager J.