Installing MySQL on NetWare
106
the Web (for example, MySQL 4.1 or later) in
SYS:\MYSQL
, you must rename the folder before
upgrading the NetWare server; otherwise, files in
SYS:\MySQL
are overwritten by the MySQL
version present in NetWare Support Pack.
5. At the server console, add a search path for the directory containing the MySQL NLMs. For
example:
SERVER: SEARCH ADD SYS:MYSQL\BIN
6. Initialize the data directory and the grant tables, if necessary, by executing
mysql_install_db
at
the server console.
7. Start the MySQL server using
mysqld_safe
at the server console.
8. To finish the installation, you should also add the following commands to
autoexec.ncf
. For
example, if your MySQL installation is in
SYS:MYSQL
and you want MySQL to start automatically,
you could add these lines:
#Starts the MySQL 5.0.x database server
SEARCH ADD SYS:MYSQL\BIN
MYSQLD_SAFE
If you are running MySQL on NetWare 6.0, we strongly suggest that you use the
--skip-
external-locking
[420]
option on the command line:
#Starts the MySQL 5.0.x database server
SEARCH ADD SYS:MYSQL\BIN
MYSQLD_SAFE --skip-external-locking
It is also necessary to use
CHECK TABLE
and
REPAIR TABLE
instead of
myisamchk
, because
myisamchk
makes use of external locking. External locking is known to have problems on
NetWare 6.0; the problem has been eliminated in NetWare 6.5. Note that the use of MySQL on
Netware 6.0 is not officially supported.
mysqld_safe
on NetWare provides a screen presence. When you unload (shut down) the
mysqld_safe
NLM, the screen does not go away by default. Instead, it prompts for user input:
*<NLM has terminated; Press any key to close the screen>*
If you want NetWare to close the screen automatically instead, use the
--autoclose
[247]
option to
mysqld_safe
. For example:
#Starts the MySQL 5.0.x database server
SEARCH ADD SYS:MYSQL\BIN
MYSQLD_SAFE --autoclose
The behavior of
mysqld_safe
on NetWare is described further in
Section 4.3.2, “
mysqld_safe
— MySQL Server Startup Script”
.
9. When installing MySQL, either for the first time or upgrading from a previous version, download and
install the latest and appropriate Perl module and PHP extensions for NetWare:
• Perl:
http://forge.novell.com/modules/xfcontent/downloads.php/perl/Modules/
• PHP:
http://forge.novell.com/modules/xfcontent/downloads.php/php/Modules/
If there was an existing installation of MySQL on the NetWare server, be sure to check for existing
MySQL startup commands in
autoexec.ncf
, and edit or delete them as necessary.
Note
The accounts that are listed in the MySQL grant tables initially have no
passwords. After starting the server, you should set up passwords for them
using the instructions in
Section 2.18, “Postinstallation Setup and Testing”
.
Summary of Contents for 5.0
Page 1: ...MySQL 5 0 Reference Manual ...
Page 18: ...xviii ...
Page 60: ...40 ...
Page 396: ...376 ...
Page 578: ...558 ...
Page 636: ...616 ...
Page 844: ...824 ...
Page 1234: ...1214 ...
Page 1427: ...MySQL Proxy Scripting 1407 ...
Page 1734: ...1714 ...
Page 1752: ...1732 ...
Page 1783: ...Configuring Connector ODBC 1763 ...
Page 1793: ...Connector ODBC Examples 1773 ...
Page 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Page 2850: ...2830 ...
Page 2854: ...2834 ...
Page 2928: ...2908 ...
Page 3000: ...2980 ...
Page 3122: ...3102 ...
Page 3126: ...3106 ...
Page 3174: ...3154 ...
Page 3232: ...3212 ...