Oracle 5.0, Reference Manual

Page: 124 / 3232

Installing MySQL on i5/OS
104
•
CURINST('path to previous install')
: The full path to the installation that is being
upgraded. For example an installation in
/QOpenSys/usr/local/
will be
/QOpenSys/usr/
local/mysql-5.1.30-i5os-power64
. Failure to specify this option may result in corruption of
your existing data files.
For example:
MYSQLINST/UPGMYSQL DIR( '/QOpenSys/usr/local/' ) DATADIR( '/QOpenSys/mysql/data' ) »
USERPRF( MYSQL ) MYSQLUSR( 'root' ) PASSWORD( 'root' ) CURINST( '/QOpenSys/usr/local/mysql-5.1.30-i5os-power64' )
You should receive a Program Message indicating
UPGRADE SUCCESSFUL!
upon completion or an
error message if there is a problem.You can view the upgrade programs progression and the error in
the text file
upgrade.log
in the installation directory.
To start MySQL:
1. Log into the System i server using the user profile create or specified during installation. By default,
this is
MYSQL
.
Note
You should start
mysqld_safe
using a user that in the PASE environment
has the id=0 (the equivalent of the standard Unix
root
user). If you do
not use a user with this ID then the system will be unable to change the
user when executing
mysqld
as set using
--user
option. If this happens,
mysqld
may be unable to read the files located within the MySQL data
directory and the execution will fail.
2. Enter the PASE environment using
call qp2term
.
3. Start the MySQL server by changing to the installation directory and running
mysqld_safe
,
specifying the user name used to install the server. The installer conveniently installs a symbolic
link to the installation directory (
mysql-5.0.42-i5os-power-32bit
) as
/opt/mysql/mysql
:
> cd /opt/mysql/mysql
> bin/mysqld_safe --user=mysql &
You should see a message similar to the following:
Starting mysqld daemon with databases »
from /opt/mysql/mysql-enterprise-5.0.42-i5os-power-32bit/data
If you are having problems starting MySQL server, see Section 2.18.1.3, “Starting and Troubleshooting
the MySQL Server” .
To stop MySQL:
1. Log into the System i server using the user profile create or specified during installation. By default,
this is
MYSQL
.
2. Enter the PASE environment using
call qp2term
.
3. Stop the MySQL server by changing into the installation directory and running
mysqladmin
,
specifying the user name used to install the server:
> cd /opt/mysql/mysql
> bin/mysqladmin -u root shutdown
If the session that you started and stopped MySQL are the same, you may get the log output from
mysqld
:
STOPPING server from pid file »
/opt/mysql/mysql-enterprise-5.0.42-i5os-power-32bit/data/I5DBX.RCHLAND.IBM.COM.pid
070718 10:34:20 mysqld ended