MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:mcbrown Date:August 11 2007 5:45am
Subject:svn commit - mysqldoc@docsrva: r7438 - trunk/refman-5.0
View as plain text  
Author: mcbrown
Date: 2007-08-11 07:45:25 +0200 (Sat, 11 Aug 2007)
New Revision: 7438

Log:
Some additions/improvements to the i5/OS content
Merging the config-wizard.xml file into the main text (there's no reason for it to be separate anymore)
Updating dependencies



Removed:
   trunk/refman-5.0/config-wizard.xml
Modified:
   trunk/refman-5.0/Makefile.depends
   trunk/refman-5.0/installing-cs.xml


Modified: trunk/refman-5.0/Makefile.depends
===================================================================
--- trunk/refman-5.0/Makefile.depends	2007-08-11 04:17:24 UTC (rev 7437)
+++ trunk/refman-5.0/Makefile.depends	2007-08-11 05:45:25 UTC (rev 7438)
Changed blocks: 7, Lines Added: 3, Lines Deleted: 44; 3591 bytes

@@ -111,47 +111,6 @@
 client-utility-programs-manprepped.xml: $(client_utility_programs_SOURCES) $(client_utility_programs_IDMAPS)
 client-utility-programs-remprepped.xml: $(client_utility_programs_SOURCES) $(client_utility_programs_IDMAPS)
 
-config_wizard_INCLUDES = \
-	../common/fixedchars.ent \
-	../common/phrases.ent \
-	../refman-common/urls.ent \
-	all-entities.ent \
-	images/published/mysql-cfg-fig1.png \
-	images/published/mysql-cfg-fig10.png \
-	images/published/mysql-cfg-fig2.png \
-	images/published/mysql-cfg-fig3.png \
-	images/published/mysql-cfg-fig4.png \
-	images/published/mysql-cfg-fig5.png \
-	images/published/mysql-cfg-fig6.png \
-	images/published/mysql-cfg-fig7.png \
-	images/published/mysql-cfg-fig8.png \
-	images/published/mysql-cfg-fig9.png \
-	versions.ent
-config_wizard_IMAGES = \
-	images/published/mysql-cfg-fig1.png \
-	images/published/mysql-cfg-fig10.png \
-	images/published/mysql-cfg-fig2.png \
-	images/published/mysql-cfg-fig3.png \
-	images/published/mysql-cfg-fig4.png \
-	images/published/mysql-cfg-fig5.png \
-	images/published/mysql-cfg-fig6.png \
-	images/published/mysql-cfg-fig7.png \
-	images/published/mysql-cfg-fig8.png \
-	images/published/mysql-cfg-fig9.png
-config_wizard_SOURCES = config-wizard.xml $(config_wizard_INCLUDES)
-config_wizard_IDMAPS = \
-	../refman-common/metadata/bug-reports.idmap \
-	metadata/dba-core.idmap \
-	metadata/installing-cs.idmap
-config-wizard.validpure: $(config_wizard_SOURCES)
-config-wizard.titles: $(config_wizard_SOURCES)
-config-wizard.useless: $(config_wizard_SOURCES)
-config-wizard.valid: $(config_wizard_SOURCES) $(config_wizard_IDMAPS)
-config-wizard.validwarn: $(config_wizard_SOURCES) $(config_wizard_IDMAPS)
-config-wizard-prepped.xml: $(config_wizard_SOURCES) $(config_wizard_IDMAPS)
-config-wizard-manprepped.xml: $(config_wizard_SOURCES) $(config_wizard_IDMAPS)
-config-wizard-remprepped.xml: $(config_wizard_SOURCES) $(config_wizard_IDMAPS)
-
 connectors_INCLUDES = \
 	../common/fixedchars.ent \
 	../common/phrases.ent \

@@ -595,7 +554,6 @@
 	../common/phrases.ent \
 	../refman-common/urls.ent \
 	all-entities.ent \
-	config-wizard.xml \
 	images/published/mysql-cfg-fig1.png \
 	images/published/mysql-cfg-fig10.png \
 	images/published/mysql-cfg-fig2.png \

@@ -633,6 +591,7 @@
 	metadata/apis-c.idmap \
 	metadata/charset.idmap \
 	metadata/client-utility-programs.idmap \
+	metadata/config-wizard.idmap \
 	metadata/connectors.idmap \
 	metadata/data-types.idmap \
 	metadata/dba-core.idmap \

@@ -710,7 +669,6 @@
 	../common/phrases.ent \
 	../refman-common/urls.ent \
 	all-entities.ent \
-	config-wizard.xml \
 	images/published/mysql-cfg-fig1.png \
 	images/published/mysql-cfg-fig10.png \
 	images/published/mysql-cfg-fig2.png \

@@ -753,6 +711,7 @@
 	metadata/apis-c.idmap \
 	metadata/charset.idmap \
 	metadata/client-utility-programs.idmap \
+	metadata/config-wizard.idmap \
 	metadata/connectors.idmap \
 	metadata/data-types.idmap \
 	metadata/dba-core.idmap \

@@ -966,7 +925,6 @@
 	apis.xml \
 	charset.xml \
 	client-utility-programs.xml \
-	config-wizard.xml \
 	connectors.xml \
 	copyright.xml \
 	data-types.xml \

@@ -1123,6 +1081,7 @@
 	../refman-4.1/metadata/introduction.idmap \
 	../refman-4.1/metadata/manual.idmap \
 	../refman-common/metadata/gpl-license.idmap \
+	metadata/config-wizard.idmap \
 	metadata/dba-core.idmap \
 	metadata/functions-core.idmap \
 	metadata/installing-outline.idmap


Modified: trunk/refman-5.0/installing-cs.xml
===================================================================
--- trunk/refman-5.0/installing-cs.xml	2007-08-11 04:17:24 UTC (rev 7437)
+++ trunk/refman-5.0/installing-cs.xml	2007-08-11 05:45:25 UTC (rev 7438)
Changed blocks: 7, Lines Added: 967, Lines Deleted: 40; 43157 bytes

@@ -2487,8 +2487,8 @@
 
       <listitem>
         <para>
-          A 32-bit Windows operating system such as 2000, XP, Vista, or Windows
-          Server 2003.
+          A 32-bit Windows operating system such as 2000, XP, Vista, or
+          Windows Server 2003.
         </para>
 
         <para>

@@ -2764,28 +2764,30 @@
           download is contained within a Zip archive, you need to
           extract the archive first.
         </para>
-        
+
         <note>
           <para>
-            If you are installing on Windows Vista it is best to open a port 
-            before beginning the installation. To do this first ensure that you 
-            are logged in as an administrator, go to the 
-            <literal>Control Panel</literal>, and double click the 
-            <literal>Windows Firewall</literal> icon.
-            Choose the <literal>Allow a program through Windows Firewall</literal> option
-            and click the <guibutton>Add port</guibutton> button.
-            Enter <literal>MySQL</literal> into the <guilabel>Name</guilabel>
-            text box and <literal>3306</literal>  (or the port of your choice)
-            into the <guilabel>Port number</guilabel> text box.
-            Also ensure that the <guilabel>TCP</guilabel> protocol radio button is selected.
-            If you wish, you can also limit access to the MySQL server
-            by choosing the <guilabel>Change scope</guilabel> button.
-            Confirm your choices by clicking the <guibutton>OK</guibutton> button.
-            If you do not open a port prior to installation, you cannot configure
-            the MySQL server immediately after installation.
-            Additionally, when running the MySQL Installation Wizard
-            on Windows Vista, ensure that you are logged in as a user with
-            administrative rights.
+            If you are installing on Windows Vista it is best to open a
+            port before beginning the installation. To do this first
+            ensure that you are logged in as an administrator, go to the
+            <literal>Control Panel</literal>, and double click the
+            <literal>Windows Firewall</literal> icon. Choose the
+            <literal>Allow a program through Windows Firewall</literal>
+            option and click the <guibutton>Add port</guibutton> button.
+            Enter <literal>MySQL</literal> into the
+            <guilabel>Name</guilabel> text box and
+            <literal>3306</literal> (or the port of your choice) into
+            the <guilabel>Port number</guilabel> text box. Also ensure
+            that the <guilabel>TCP</guilabel> protocol radio button is
+            selected. If you wish, you can also limit access to the
+            MySQL server by choosing the <guilabel>Change
+            scope</guilabel> button. Confirm your choices by clicking
+            the <guibutton>OK</guibutton> button. If you do not open a
+            port prior to installation, you cannot configure the MySQL
+            server immediately after installation. Additionally, when
+            running the MySQL Installation Wizard on Windows Vista,
+            ensure that you are logged in as a user with administrative
+            rights.
           </para>
         </note>
 

@@ -3143,8 +3145,828 @@
 
     </section>
 
-    <xi:include href="config-wizard.xml"  xmlns:xi="http://www.w3.org/2001/XInclude"/>
+    <section id="mysql-config-wizard" role="cses">
 
+      <title>MySQL Server Configuration Wizard</title>
+
+      <para>
+        The MySQL Server Configuration Wizard helps automate the process
+        of configuring your server. It creates a custom MySQL
+        configuration file (<filename>my.ini</filename> or
+        <filename>my.cnf</filename>) by asking you a series of questions
+        and then applying your responses to a template to generate the
+        configuration file that is tuned to your installation.
+      </para>
+
+      <para>
+        The MySQL Server Configuration Wizard is included with the MySQL
+        &current-series; server. For Community Server users, the MySQL
+        Server Configuration Wizard is available only for Windows. For
+        Enterprise Server users, the MySQL Server Configuration Wizard
+        is included as part of the standard Enterprise Installer.
+      </para>
+
+      <para>
+        The MySQL Server Configuration Wizard is to a large extent the
+        result of feedback that MySQL AB has received from many users
+        over a period of several years. However, if you find that it
+        lacks some feature important to you, please report it in our
+        bugs database using the instructions given in
+        <xref linkend="bug-reports"/>.
+      </para>
+
+      <section id="mysql-config-wizard-starting" role="cses">
+
+        <title>Starting the MySQL Server Configuration Wizard</title>
+
+        <para>
+          The MySQL Server Configuration Wizard is normally started as
+          part of the installation process. You should only need to run
+          the MySQL Server Configuration Wizard again when you need to
+          change the configuration parameters of your server.
+        </para>
+
+        <para>
+          If you chose not to open a port prior to installing MySQL on
+          Windows Vista, you can choose to use the MySQL Server
+          Configuration Wizard after installation. However, you must
+          open a port in the Windows Firewall. To do this see the
+          instructions given in
+          <xref linkend="mysql-install-wizard-starting"/>. Rather than
+          opening a port, you also have the option of adding MySQL as a
+          program that bypasses the Windows Firewall. One or the other
+          option is sufficient &mdash; you need not do both.
+          Additionally, when running the MySQL Server Configuration
+          Wizard on Windows Vista ensure that you are logged in as a
+          user with administrative rights.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig1.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard</phrase>
+          </textobject>
+        </mediaobject>
+
+        <section id="mysql-config-wizard-starting-windows" role="cses">
+
+          <title>The MySQL Server Configuration Wizard on Windows</title>
+
+          <para>
+            You can launch the MySQL Configuration Wizard by clicking
+            the <guimenuitem>MySQL Server Instance Config
+            Wizard</guimenuitem> entry in the
+            <guisubmenu>MySQL</guisubmenu> section of the Windows
+            <guimenu>Start</guimenu> menu.
+          </para>
+
+          <para>
+            Alternatively, you can navigate to the
+            <filename>bin</filename> directory of your MySQL
+            installation and launch the
+            <filename>MySQLInstanceConfig.exe</filename> file directly.
+          </para>
+
+          <para>
+            The MySQL Server Configuration Wizard places the
+            <filename>my.ini</filename> file in the installation
+            directory for the MySQL server. This helps associate
+            configuration files with particular server instances.
+          </para>
+
+          <para>
+            To ensure that the MySQL server knows where to look for the
+            <filename>my.ini</filename> file, an argument similar to
+            this is passed to the MySQL server as part of the service
+            installation:
+          </para>
+
+<programlisting>
+--defaults-file="<replaceable>C:\Program Files\MySQL\MySQL Server &current-series;</replaceable>\my.ini"
+</programlisting>
+
+          <para>
+            Here, <replaceable>C:\Program Files\MySQL\MySQL Server
+            &current-series;</replaceable> is replaced with the
+            installation path to the MySQL Server. The
+            <option>--defaults-file</option> option instructs the MySQL
+            server to read the specified file for configuration options
+            when it starts.
+          </para>
+
+          <para>
+            Apart from making changes to the <filename>my.ini</filename>
+            file by running the MySQL Server Configuration Wizard again,
+            you can modify it by opening it with a text editor and
+            making any necessary changes. You can also modify the server
+            configuration with the
+            <ulink url="http://www.mysql.com/products/administrator/">MySQL
+            Administrator</ulink> utility. For more information about
+            server configuration, see <xref linkend="server-options"/>.
+          </para>
+
+          <para>
+            MySQL clients and utilities such as the
+            <command>mysql</command> and <command>mysqldump</command>
+            command-line clients are not able to locate the
+            <filename>my.ini</filename> file located in the server
+            installation directory. To configure the client and utility
+            applications, create a new <filename>my.ini</filename> file
+            in the Windows installation directory (for example,
+            <filename>C:\WINDOWS</filename>).
+          </para>
+
+          <para>
+            <remark role="update">
+              [SH] Amend the list with Windows Vista once it's there
+            </remark>
+
+            Under Windows Server 2003, Windows Server 2000 and Windows
+            XP, MySQL Server Configuration Wizard will configure MySQL
+            to work as a Windows service. To start and stop MySQL you
+            use the <filename>Services</filename> application that is
+            supplied as part of the Windows Administrator Tools.
+          </para>
+
+        </section>
+
+        <section id="mysql-config-wizard-starting-linux" role="es">
+
+          <title>Starting the MySQL Server Configuration Wizard on Linux</title>
+
+          &es-only;
+          
+          <para>
+            To start the MySQL Configuration Wizard on Linux, you must
+            run the <literal>mysqlsetup</literal> command. You must be
+            running an X Windows System server for the MySQL Server
+            Configuration Wizard.
+          </para>
+
+          <para>
+            To display the MySQL Server Configuration Wizard interface
+            on a different machine, set the value of the
+            <literal>DISPLAY</literal> variable on the command line:
+          </para>
+
+<programlisting>shell&gt;
+DISPLAY=<replaceable>remote:0.0</replaceable> mysqlsetup</programlisting>
+
+          <para>
+            The MySQL Server Configuration Wizard places the
+            <filename>my.cnf</filename> file in the
+            <filename>/etc</filename> directory.
+          </para>
+
+          <para>
+            This configuration file is automatically used when
+            <literal>mysqld</literal> is started. The standard MySQL
+            server initialization script, typically located within
+            <filename>/etc/init.d/mysql</filename>, will also use this
+            file automatically.
+          </para>
+
+          <para>
+            Apart from making changes to the <filename>my.ini</filename>
+            file by running the MySQL Server Configuration Wizard again,
+            you can modify it by opening it with a text editor and
+            making any necessary changes. You can also modify the server
+            configuration with the
+            <ulink url="http://www.mysql.com/products/administrator/">MySQL
+            Administrator</ulink> utility. For more information about
+            server configuration, see <xref linkend="server-options"/>.
+          </para>
+
+        </section>
+
+      </section>
+
+      <section id="mysql-config-wizard-maintenance" role="cses">
+
+        <title>Choosing a Maintenance Option</title>
+
+        <para>
+          If the MySQL Server Configuration Wizard detects an existing
+          configuration file, you have the option of either
+          reconfiguring your existing server, or removing the server
+          instance by deleting the configuration file and stopping and
+          removing the MySQL service.
+        </para>
+
+        <para>
+          To reconfigure an existing server, choose the
+          <guimenuitem>Re-configure Instance</guimenuitem> option and
+          click the <guibutton>Next</guibutton> button. Any existing
+          configuration file is not overwritten, but renamed (within the
+          same directory) using a timestamp (Windows) or sequential
+          number (Linux). To remove the existing server instance, choose
+          the <guimenuitem>Remove Instance</guimenuitem> option and
+          click the <guibutton>Next</guibutton> button.
+        </para>
+
+        <para>
+          If you choose the <guimenuitem>Remove Instance</guimenuitem>
+          option, you advance to a confirmation window. Click the
+          <guibutton>Execute</guibutton> button. The MySQL Server
+          Configuration Wizard stops and removes the MySQL service, and
+          then deletes the configuration file. The server installation
+          and its <filename>data</filename> folder are not removed.
+        </para>
+
+        <para>
+          If you choose the <guimenuitem>Re-configure
+          Instance</guimenuitem> option, you advance to the
+          <guimenu>Configuration Type</guimenu> dialog where you can
+          choose the type of installation that you wish to configure.
+        </para>
+
+      </section>
+
+      <section id="mysql-config-wizard-configuration-type" role="cses">
+
+        <title>Choosing a Configuration Type</title>
+
+        <para>
+          When you start the MySQL Server Configuration Wizard for a new
+          MySQL installation, or choose the <guimenuitem>Re-configure
+          Instance</guimenuitem> option for an existing installation,
+          you advance to the <guimenu>Configuration Type</guimenu>
+          dialog.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig2.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard:
+            Configuration Type</phrase>
+          </textobject>
+        </mediaobject>
+
+        <para>
+          There are two configuration types available:
+          <guimenuitem>Detailed Configuration</guimenuitem> and
+          <guimenuitem>Standard Configuration</guimenuitem>. The
+          <guimenuitem>Standard Configuration</guimenuitem> option is
+          intended for new users who want to get started with MySQL
+          quickly without having to make many decisions about server
+          configuration. The <guimenuitem>Detailed
+          Configuration</guimenuitem> option is intended for advanced
+          users who want more fine-grained control over server
+          configuration.
+        </para>
+
+        <para>
+          If you are new to MySQL and need a server configured as a
+          single-user developer machine, the <guimenuitem>Standard
+          Configuration</guimenuitem> should suit your needs. Choosing
+          the <guimenuitem>Standard Configuration</guimenuitem> option
+          causes the MySQL Configuration Wizard to set all configuration
+          options automatically with the exception of
+          <guimenuitem>Service Options</guimenuitem> and
+          <guimenuitem>Security Options</guimenuitem>.
+        </para>
+
+        <para>
+          The <guimenuitem>Standard Configuration</guimenuitem> sets
+          options that may be incompatible with systems where there are
+          existing MySQL installations. If you have an existing MySQL
+          installation on your system in addition to the installation
+          you wish to configure, the <guimenuitem>Detailed
+          Configuration</guimenuitem> option is recommended.
+        </para>
+
+        <para>
+          To complete the <guimenuitem>Standard
+          Configuration</guimenuitem>, please refer to the sections on
+          <guimenuitem>Service Options</guimenuitem> and
+          <guimenuitem>Security Options</guimenuitem> in
+          <xref linkend="mysql-config-wizard-service"/>, and
+          <xref linkend="mysql-config-wizard-security"/>, respectively.
+        </para>
+
+      </section>
+
+      <section id="mysql-config-wizard-server-type" role="cses">
+
+        <title>The Server Type Dialog</title>
+
+        <para>
+          There are three different server types available to choose
+          from. The server type that you choose affects the decisions
+          that the MySQL Server Configuration Wizard makes with regard
+          to memory, disk, and processor usage.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig3.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard: Server
+            Type</phrase>
+          </textobject>
+        </mediaobject>
+
+        <itemizedlist>
+
+          <listitem>
+            <para>
+              <guimenuitem>Developer Machine</guimenuitem>: Choose this
+              option for a typical desktop workstation where MySQL is
+              intended only for personal use. It is assumed that many
+              other desktop applications are running. The MySQL server
+              is configured to use minimal system resources.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Server Machine</guimenuitem>: Choose this
+              option for a server machine where the MySQL server is
+              running alongside other server applications such as FTP,
+              email, and Web servers. The MySQL server is configured to
+              use a moderate portion of the system resources.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Dedicated MySQL Server Machine</guimenuitem>:
+              Choose this option for a server machine that is intended
+              to run only the MySQL server. It is assumed that no other
+              applications are running. The MySQL server is configured
+              to use all available system resources.
+            </para>
+          </listitem>
+
+        </itemizedlist>
+
+        <note>
+          <para>
+            By selecting one of the preconfigured configurations, the
+            values and settings of various options in your
+            <filename>my.cnf</filename> or <filename>my.ini</filename>
+            will be altered accordingly. The default values and options
+            as described in the reference manual may therefore be
+            different to the options and values that were created during
+            the execution of the configuration wizard.
+          </para>
+        </note>
+
+      </section>
+
+      <section id="mysql-config-wizard-database-usage" role="cses">
+
+        <title>The Database Usage Dialog</title>
+
+        <para>
+          The <guimenu>Database Usage</guimenu> dialog allows you to
+          indicate the storage engines that you expect to use when
+          creating MySQL tables. The option you choose determines
+          whether the <literal>InnoDB</literal> storage engine is
+          available and what percentage of the server resources are
+          available to <literal>InnoDB</literal>.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig4.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard: Usage
+            Dialog</phrase>
+          </textobject>
+        </mediaobject>
+
+        <itemizedlist>
+
+          <listitem>
+            <para>
+              <guimenuitem>Multifunctional Database</guimenuitem>: This
+              option enables both the <literal>InnoDB</literal> and
+              <literal>MyISAM</literal> storage engines and divides
+              resources evenly between the two. This option is
+              recommended for users who use both storage engines on a
+              regular basis.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Transactional Database Only</guimenuitem>:
+              This option enables both the <literal>InnoDB</literal> and
+              <literal>MyISAM</literal> storage engines, but dedicates
+              most server resources to the <literal>InnoDB</literal>
+              storage engine. This option is recommended for users who
+              use <literal>InnoDB</literal> almost exclusively and make
+              only minimal use of <literal>MyISAM</literal>.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Non-Transactional Database
+              Only</guimenuitem>: This option disables the
+              <literal>InnoDB</literal> storage engine completely and
+              dedicates all server resources to the
+              <literal>MyISAM</literal> storage engine. This option is
+              recommended for users who do not use
+              <literal>InnoDB</literal>.
+            </para>
+          </listitem>
+
+        </itemizedlist>
+
+      </section>
+
+      <section id="mysql-config-wizard-tablespace" role="cses">
+
+        <title>The InnoDB Tablespace Dialog</title>
+
+        <para>
+          Some users may want to locate the <literal>InnoDB</literal>
+          tablespace files in a different location than the MySQL server
+          data directory. Placing the tablespace files in a separate
+          location can be desirable if your system has a higher capacity
+          or higher performance storage device available, such as a RAID
+          storage system.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig5.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard: InnoDB
+            Data Tablespace</phrase>
+          </textobject>
+        </mediaobject>
+
+        <para>
+          To change the default location for the
+          <literal>InnoDB</literal> tablespace files, choose a new drive
+          from the drop-down list of drive letters and choose a new path
+          from the drop-down list of paths. To create a custom path,
+          click the <guibutton>...</guibutton> button.
+        </para>
+
+        <para>
+          If you are modifying the configuration of an existing server,
+          you must click the <guibutton>Modify</guibutton> button before
+          you change the path. In this situation you must move the
+          existing tablespace files to the new location manually before
+          starting the server.
+        </para>
+
+      </section>
+
+      <section id="mysql-config-wizard-connections" role="cses">
+
+        <title>The Concurrent Connections Dialog</title>
+
+        <para>
+          To prevent the server from running out of resources, it is
+          important to limit the number of concurrent connections to the
+          MySQL server that can be established. The <guimenu>Concurrent
+          Connections</guimenu> dialog allows you to choose the expected
+          usage of your server, and sets the limit for concurrent
+          connections accordingly. It is also possible to set the
+          concurrent connection limit manually.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig6.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard:
+            Connections</phrase>
+          </textobject>
+        </mediaobject>
+
+        <itemizedlist>
+
+          <listitem>
+            <para>
+              <guimenuitem>Decision Support (DSS)/OLAP</guimenuitem>:
+              Choose this option if your server does not require a large
+              number of concurrent connections. The maximum number of
+              connections is set at 100, with an average of 20
+              concurrent connections assumed.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Online Transaction Processing
+              (OLTP)</guimenuitem>: Choose this option if your server
+              requires a large number of concurrent connections. The
+              maximum number of connections is set at 500.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Manual Setting</guimenuitem>: Choose this
+              option to set the maximum number of concurrent connections
+              to the server manually. Choose the number of concurrent
+              connections from the drop-down box provided, or enter the
+              maximum number of connections into the drop-down box if
+              the number you desire is not listed.
+            </para>
+          </listitem>
+
+        </itemizedlist>
+
+      </section>
+
+      <section id="mysql-config-wizard-networking" role="cses">
+
+        <title>The Networking and Strict Mode Options Dialog</title>
+
+        <para>
+          Use the <guimenu>Networking Options</guimenu> dialog to enable
+          or disable TCP/IP networking and to configure the port number
+          that is used to connect to the MySQL server.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig7.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard: Network
+            Configuration</phrase>
+          </textobject>
+        </mediaobject>
+
+        <para>
+          TCP/IP networking is enabled by default. To disable TCP/IP
+          networking, uncheck the box next to the <guimenuitem>Enable
+          TCP/IP Networking</guimenuitem> option.
+        </para>
+
+        <para>
+          Port 3306 is used by default. To change the port used to
+          access MySQL, choose a new port number from the drop-down box
+          or type a new port number directly into the drop-down box. If
+          the port number you choose is in use, you are prompted to
+          confirm your choice of port number.
+        </para>
+
+        <para>
+          Set the <guimenu>Server SQL Mode</guimenu> to either enable or
+          disable strict mode. Enabling strict mode (default) makes
+          MySQL behave more like other database management systems.
+          <emphasis>If you run applications that rely on MySQL's old
+          <quote>forgiving</quote> behavior, make sure to either adapt
+          those applications or to disable strict mode.</emphasis> For
+          more information about strict mode, see
+          <xref linkend="server-sql-mode"/>.
+        </para>
+
+      </section>
+
+      <section id="mysql-config-wizard-character-set" role="cses">
+
+        <title>The Character Set Dialog</title>
+
+        <para>
+          The MySQL server supports multiple character sets and it is
+          possible to set a default server character set that is applied
+          to all tables, columns, and databases unless overridden. Use
+          the <guimenu>Character Set</guimenu> dialog to change the
+          default character set of the MySQL server.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig8.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard:
+            Character Set</phrase>
+          </textobject>
+        </mediaobject>
+
+        <itemizedlist>
+
+          <listitem>
+            <para>
+              <guimenuitem>Standard Character Set</guimenuitem>: Choose
+              this option if you want to use <literal>latin1</literal>
+              as the default server character set.
+              <literal>latin1</literal> is used for English and many
+              Western European languages.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Best Support For
+              Multilingualism</guimenuitem>: Choose this option if you
+              want to use <literal>utf8</literal> as the default server
+              character set. This is a Unicode character set that can
+              store characters from many different languages.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <guimenuitem>Manual Selected Default Character Set /
+              Collation</guimenuitem>: Choose this option if you want to
+              pick the server's default character set manually. Choose
+              the desired character set from the provided drop-down
+              list.
+            </para>
+          </listitem>
+
+        </itemizedlist>
+
+      </section>
+
+      <section id="mysql-config-wizard-service" role="es">
+
+        <title>The Service Options Dialog</title>
+      
+        &es-only;
+        
+        <para>
+          On Windows platforms, the MySQL server can be installed as a
+          Windows service. When installed this way, the MySQL server can
+          be started automatically during system startup, and even
+          restarted automatically by Windows in the event of a service
+          failure.
+        </para>
+
+        <para>
+          The MySQL Server Configuration Wizard installs the MySQL
+          server as a service by default, using the service name
+          <literal>MySQL</literal>. If you do not wish to install the
+          service, uncheck the box next to the <guimenuitem>Install As
+          Windows Service</guimenuitem> option. You can change the
+          service name by picking a new service name from the drop-down
+          box provided or by entering a new service name into the
+          drop-down box.
+        </para>
+
+        <para>
+          To install the MySQL server as a service but not have it
+          started automatically at startup, uncheck the box next to the
+          <guimenuitem>Launch the MySQL Server
+          Automatically</guimenuitem> option.
+        </para>
+
+      </section>
+
+      <section id="mysql-config-wizard-security" role="cses">
+
+        <title>The Security Options Dialog</title>
+
+        <para>
+          <emphasis>It is strongly recommended that you set a
+          <literal>root</literal> password for your MySQL
+          server</emphasis>, and the MySQL Server Configuration Wizard
+          requires by default that you do so. If you do not wish to set
+          a <literal>root</literal> password, uncheck the box next to
+          the <guimenuitem>Modify Security Settings</guimenuitem>
+          option.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig9.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard:
+            Security</phrase>
+          </textobject>
+        </mediaobject>
+
+        <para>
+          To set the <literal>root</literal> password, enter the desired
+          password into both the <guimenuitem>New root
+          password</guimenuitem> and <guimenuitem>Confirm</guimenuitem>
+          boxes. If you are reconfiguring an existing server, you need
+          to enter the existing <literal>root</literal> password into
+          the <guimenuitem>Current root password</guimenuitem> box.
+        </para>
+
+        <para>
+          To prevent <literal>root</literal> logins from across the
+          network, check the box next to the <guimenuitem>Root may only
+          connect from localhost</guimenuitem> option. This increases
+          the security of your <literal>root</literal> account.
+        </para>
+
+        <para>
+          <remark role="todo">
+            [SH] Depending on how this will (or won't) be changed in the
+            Enterprise Installer, this paragraph needs to be reworked.
+          </remark>
+
+          To create an anonymous user account, check the box next to the
+          <guimenuitem>Create An Anonymous Account</guimenuitem> option.
+          Creating an anonymous account can decrease server security and
+          cause login and permission difficulties. For this reason, it
+          is not recommended.
+        </para>
+
+      </section>
+
+      <section id="mysql-config-wizard-confirmation" role="cses">
+
+        <title>The Confirmation Dialog</title>
+
+        <para>
+          The final dialog in the MySQL Server Configuration Wizard is
+          the <guimenu>Confirmation Dialog</guimenu>. To start the
+          configuration process, click the
+          <guibutton>Execute</guibutton> button. To return to a previous
+          dialog, click the <guibutton>Back</guibutton> button. To exit
+          the MySQL Server Configuration Wizard without configuring the
+          server, click the <guibutton>Cancel</guibutton> button.
+        </para>
+
+        <mediaobject>
+          <imageobject>
+            <imagedata
+              fileref="images/published/mysql-cfg-fig10.png"
+              format="PNG"/>
+          </imageobject>
+          <textobject>
+            <phrase lang="en">MySQL Server Configuration Wizard:
+            Confirmation</phrase>
+          </textobject>
+        </mediaobject>
+
+        <para>
+          After you click the <guibutton>Execute</guibutton> button, the
+          MySQL Server Configuration Wizard performs a series of tasks
+          and displays the progress onscreen as the tasks are performed.
+        </para>
+
+        <para>
+          The MySQL Server Configuration Wizard first determines
+          configuration file options based on your choices using a
+          template prepared by MySQL AB developers and engineers. This
+          template is named <filename>my-template.ini</filename> and is
+          located in your server installation directory.
+        </para>
+
+        <para>
+          The MySQL Configuration Wizard then writes these options to
+          the corresponding configuration file.
+        </para>
+
+        <para>
+          If you chose to create a service for the MySQL server, the
+          MySQL Server Configuration Wizard creates and starts the
+          service. If you are reconfiguring an existing service, the
+          MySQL Server Configuration Wizard restarts the service to
+          apply your configuration changes.
+        </para>
+
+        <para>
+          If you chose to set a <literal>root</literal> password, the
+          MySQL Configuration Wizard connects to the server, sets your
+          new <literal>root</literal> password, and applies any other
+          security settings you may have selected.
+        </para>
+
+        <para>
+          After the MySQL Server Configuration Wizard has completed its
+          tasks, it displays a summary. Click the
+          <guibutton>Finish</guibutton> button to exit the MySQL Server
+          Configuration Wizard.
+        </para>
+
+      </section>
+
+    </section>
+
     <section id="windows-install-archive" role="cs">
 
       <title>Installing MySQL from a Noinstall Zip Archive</title>

@@ -3696,17 +4518,17 @@
         when Windows starts and stops. A MySQL server installed as a
         service can also be controlled from the command line using
         <command>NET</command> commands, or with the graphical
-        <command>Services</command> utility. Generally, to install
-        MySQL as a Windows service you should be logged in using an
-        account that has administrator rights.
+        <command>Services</command> utility. Generally, to install MySQL
+        as a Windows service you should be logged in using an account
+        that has administrator rights.
       </para>
 
       <para>
         The <command>Services</command> utility (the Windows
         <command>Service Control Manager</command>) can be found in the
         Windows Control Panel (under <guimenuitem>Administrative
-        Tools</guimenuitem> on Windows 2000, XP, Vista, and Server 2003). To
-        avoid conflicts, it is advisable to close the
+        Tools</guimenuitem> on Windows 2000, XP, Vista, and Server
+        2003). To avoid conflicts, it is advisable to close the
         <command>Services</command> utility while performing server
         installation or removal operations from the command line.
       </para>

@@ -5648,6 +6470,33 @@
     </para>
 
     <para>
+      You should the installation notes and tips for i5/OS before
+      starting installation. See
+      <xref linkend="installation-i5os-notes"/>.
+    </para>
+
+    <note>
+      <para>
+        The installation package will use an existing configuration if
+        you have previously installed MySQL. The values for the data
+        directory (<literal>DATADIR</literal>) and owner of the MySQL
+        files (<literal>USRPRF</literal>) specified during the
+        installation will be ignored, and the values determined from the
+        <filename>/etc/my.cnf</filename> will be used instead.
+      </para>
+
+      <para>
+        If you want to change these parameters during a new install, you
+        should temporarily rename <filename>/etc/my.cnf</filename>,
+        install MySQL using the new parameters you want to use, and then
+        merge your previous <filename>/etc/my.cnf</filename>
+        configuration settings with the new
+        <filename>/etc/my.cnf</filename> file that is created during
+        installation.
+      </para>
+    </note>
+
+    <para>
       To install MySQL on i5/OS, follow these steps:
     </para>
 

@@ -5721,25 +6570,69 @@
       <listitem>
         <para>
           You need to execute the installation command,
-          <filename>MYSQLINST/INSMYSQL</filename>. You must specify an
-          installation directory and the user profile that will own the
-          files that are installed. Both the directory and profile will
-          be created if they do not already exist. MySQL can be
-          installed anywhere, for this example we will assume MySQL has
-          been installed into <filename>/opt/mysql</filename>. The
-          <literal>MYSQL</literal> user profile that was created earlier
-          in this sequence should be used for the profile:
+          <filename>MYSQLINST/INSMYSQL</filename>. You can specify three
+          parameter settings during installation:
         </para>
 
-<programlisting>MYSQLINST/INSMYSQL DIR('/opt/mysql') USRPRF(MYSQL)</programlisting>
+        <itemizedlist>
 
+          <listitem>
+            <para>
+              <literal>DIR(<replaceable>'/opt/mysql'</replaceable>)</literal>
+              sets the installation location for the MySQL files. The
+              directory will be created if it does not already exist.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <literal>DATADIR(<replaceable>'/QOpenSys/mysal/data'</replaceable>)</literal>
+              sets the location of the directory that will be used to
+              store the database files and binary logs. The default
+              setting is <filename>/QOpenSys/mysql/data</filename>.
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
+              <literal>USRPRF(<replaceable>MYSQL</replaceable>)</literal>
+              sets the user profile that will own the files that are
+              installed. The profile will be created if it does not
+              already exist.
+            </para>
+          </listitem>
+
+        </itemizedlist>
+
         <para>
+          MySQL can be installed anywhere, for this example we will
+          assume MySQL has been installed into
+          <filename>/opt/mysql</filename>. The <literal>MYSQL</literal>
+          user profile that was created earlier in this sequence should
+          be used for the profile:
+        </para>
+
+<programlisting>MYSQLINST/INSMYSQL DIR('/opt/mysql') DATADIR('/opt/mysqldata') USRPRF(MYSQL)</programlisting>
+
+        <para>
+          If you are updating an installation over an existing MySQL
+          installation, you should use the same parameter values that
+          were used when MySQL was originally installed.
+        </para>
+
+        <para>
           The installation copies all the necessary files into a
           directory matching the package version (for example
           <filename>mysql-5.0.42-i5os-power-32bit</filename>), sets the
-          ownership on those files, sets up the MySQL environment, and
-          creates the default initial database, completing all the steps
-          in a typical binary installation process automatically.
+          ownership on those files, sets up the MySQL environment and
+          creates the MySQL configuration file (in
+          <filename>/etc/my.cnf</filename>) 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
+          <filename>/etc/my.cnf</filename> file does not exist), then
+          the initial core MySQL databases will also be created during
+          installation.
         </para>
       </listitem>
 

@@ -5864,6 +6757,40 @@
 
     </orderedlist>
 
+    <para id="installation-i5os-notes">
+      <emphasis>Note and tips</emphasis>
+    </para>
+
+    <itemizedlist>
+
+      <listitem>
+        <para>
+          A problem has been identified with the installation process on
+          DBCS systems. If you are having problems install MySQL on a
+          DBCS system, you need to change your job's coded character set
+          identifier (<literal>CSSID</literal>) to 37
+          (<literal>EBCDIC</literal>) before executing the install
+          command, <literal>INSMYSQL</literal>. To do this, determine
+          your existing <literal>CSSID</literal> (using
+          <literal>DSPJOB</literal> and selecting option 2), execute
+          <literal>CHGJOB CSSID(37)</literal>, run
+          <literal>INSMYSQL</literal> to install MySQL and then execute
+          <literal>CHGJOB</literal> again with your original
+          <literal>CSSID.</literal>
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          If you want to use the Perl scripts that are included with
+          MySQL, you need to download the iSeries Tools for Developers
+          (5799-PTL). See
+          <ulink url="http://www-03.ibm.com/servers/enable/site/porting/tools/"/>.
+        </para>
+      </listitem>
+
+    </itemizedlist>
+
   </section>
 
   <section id="netware-installation" role="cs">


Thread
svn commit - mysqldoc@docsrva: r7438 - trunk/refman-5.0mcbrown11 Aug