Installing MySQL on i5/OS
103
•
DATADIR('/QOpenSys/usr/local/mysql/data')
sets the location of the directory that
will be used to store the database files and binary logs. The default setting is
/QOpenSys/
usr/local/mysql/data
. Note that if the installer detects an existing installation (due to the
existence of
/etc/my.cnf
), then the existing setting will be used instead of the default.
•
USRPRF(MYSQL)
sets the user profile that will own the files that are installed. The profile will be
created if it does not already exist.
Note
You should choose an appropriate user for using the MySQL server
installation. The user will be used whenever you need to do any
administration on the MySQL server.
Once you have set the appropriate parameters, you can begin the installation.
The installation copies all the necessary files into a directory matching the
DIR
configuration
value; sets the ownership on those files, sets up the MySQL environment and creates the MySQL
configuration file (in
/etc/my.cnf
) completing all the steps in a typical binary installation process
automatically. If this is a new installation of MySQL, or if the installer detects that this is a new
version (because the
/etc/my.cnf
file does not exist), then the initial core MySQL databases will
also be created during installation.
Once the installation has been completed, you will get a notice advising you to set the password for
the root user. For more information,
Section 2.18, “Postinstallation Setup and Testing”
.
8. Once the installation has completed, you can delete the installation file:
DLTLIB LIB(MYSQLINST)
Upgrading an existing MySQL instance
You need to execute the upgrade command,
MYSQLINST/UPGMYSQL
.
Note
You cannot use
MYSQLINST/UPGMYSQL
to upgrade between major versions of
MySQL (for example from 5.0 to 5.1). For information and advice on migrating
between major versions you can use the advice provided in
Section 2.19.1.2,
“Upgrading from MySQL 4.1 to 5.0”
.
You must specify 6 parameters to perform an upgrade:
•
DIR('/QOpenSys/usr/local/')
: Sets the installation location for the MySQL files. The directory
will be created if it does not already exist. This is the directory that the MySQL server will be installed
into, inside a directory with a name matching the version and release. For example, if installing
MySQL 5.0.82 with the
DIR
set to
/QOpenSys/usr/local/
would result in
/QOpenSys/usr/
local/mysql-5.0.82-i5os-power64
and a symbolic link to this directory will be created in
/
QOpenSys/usr/local/mysql
.
•
DATADIR('/QOpenSys/mysql/data')
: Sets the location of the directory that will be upgraded.
•
USRPRF('MYSQL')
: Sets the user profile that will own the files that are installed. The profile will be
created if it does not already exist; if it is created as part of the upgrade process, it will be disabled
initially. You may wish to enable this user profile so that it can be used to start the MySQL server
later. It is best practice to use the one previously created during the first installation.
•
MYSQLUSR('root user')
: Any user account in the current MySQL server with
SUPER
privileges.
•
PASSWORD('root user password')
: The password for the above account. This is necessary as
the upgrade starts the MySQL server to upgrade the tables and the password is need to be able to
shutdown the MySQL server.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...