ZendDBi Installation

To install ZendDBi:

1. To begin the ZendDBi Installation, select Option 6 ‘ZendDBi Management menu ’ from the Zend Server 6 for IBM i Service menu (GO ZENDSVR6/ZSMENU):

   ZendDBi Installation Option

2. Press Enter to start the ZendDBi installation, or F3 to skip ZendDBi installation.

Note:

You can install the ZendDBi database later using the Setup Tool.
To install ZendDBi following installation:
1. Open the Setup Tool by running the command go zendsvr/zcmenu in your i/OS emulator screen.
2. Select Option 6 - ZendDBi management menu.
3. You will be prompted to install the ZendDBi database.
Note: ZendDBi must be installed by QSECOFR.

3. If ZendDBi or MySQL, are already installed in the directory /usr/local/MySQL, the following prompt will appear:

MySQL already installed

4. Press F3 to finish the installation.

5. If ZendDBi has not been previously installed, it will be installed now:

ZendDBi Installation

6. A dialog will appear reminding you to set a password for the MySQL root user:

MySQL Instructions

Note:

In addition to the instructions in the dialog, the MySQL Daemon can later be stopped/started through the Setup Tool.
To start/stop your MySQL Deamon (after the MySQL installation):
1. Open the Setup Tool by running the following command: go zendsvr6/zsmenu
2. Select Option 6 - ZendDBi Management Menu.
3. In the following screen, select Option 4 - Start ZendDBi daemon or Option 5 - Stop ZendDBi daemon.

7. Press Enter to continue.
   A confirmation message will appear stating the location of your MySQL installation.

MySQL Installation Confirmation

8. Press F3 to finish and exit the installation process.

To verify the installation:

1. Start PASE shell by typing:

QSH

2. Change to MySQL directory:

cd/usr/localmysql/bin

3. Type the following command:

mysql -u root

To uninstall MySQL:

1. Stop the ZMYSQL subsystem.
2. Delete ZMYSQL library.
3. Remove the directory /usr/local/mysql-5.0.59-i5os-power-64bit
4. Remove the directory /usr/local/mysqldata
5. Remove the link /usr/local/mysql
6. Remove /etc/my.cnf

To upgrade MySQL:

1. Stop MySQL daemon from MySQL menu.
2. Enter the following commands:

GO ZENDSVR6/ZSMENU

CALL ZMYSQLUPG1

ZendDBi Upgrade Options

3. In the MySQL Upgrade confirmation dialog, press Enter to continue.
   The ZendDBi Upgrade Information dialog displays.

Zend DBi Upgrade Information

4. Enter your old MySQL root password, and press Enter.
   A confirmation dialog is displayed stating that the upgrade to ZendDBi was completed successfully.
5. Press Enter to finish and exit the upgrade process.