| List: | Commits | « Previous MessageNext Message » | |
| From: | mcbrown | Date: | October 30 2006 5:34pm |
| Subject: | svn commit - mysqldoc@docsrva: r3799 - trunk/refman-5.0 | ||
| View as plain text | |||
Author: mcbrown Date: 2006-10-30 17:34:12 +0100 (Mon, 30 Oct 2006) New Revision: 3799 Log: Split windows-config-wizard out, remove CS/ES only, change highlighted role XInclude into current installing XInclude into new ES installing Update dependencies Added: trunk/refman-5.0/windows-config-wizard.xml Modified: trunk/refman-5.0/Makefile trunk/refman-5.0/installing-es.xml trunk/refman-5.0/installing.xml Modified: trunk/refman-5.0/Makefile =================================================================== --- trunk/refman-5.0/Makefile 2006-10-30 16:14:02 UTC (rev 3798) +++ trunk/refman-5.0/Makefile 2006-10-30 16:34:12 UTC (rev 3799) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 6665 bytes @@ -43,7 +43,7 @@ MANUAL_SRCS_EXTRA = versions.ent ../refman-common/fixedchars.ent ../refman-common/urls.ent ../refman-common/phrases.ent -MANUAL_SRCS = $(MANUAL_SRCS_EXTRA) manual.xml ../refman-common/bug-reports.xml ../refman-common/cjk-faq.en.xml ../refman-common/credits.xml ../refman-common/environment-variables.xml ../refman-common/gpl-license.xml ../refman-common/information-sources.xml ../refman-common/manual-conventions.en.xml ../refman-common/maxdb.en.xml ../refman-common/mysql-floss-license-exception.xml ../refman-common/news-cluster.xml ../refman-common/news-connector-j.xml ../refman-common/news-connector-net.xml ../refman-common/news-myodbc.xml ../refman-common/regexp.xml ../refman-common/what-is-mysql-ab.en.xml ../refman-common/what-is.en.xml apis.xml charset.xml client-utility-programs.xml connector-j.xml connector-mxj.xml connector-net.xml connector-odbc.xml connector-php.xml connectors.xml copyright.xml data-types.xml database-administration.xml dba-optvars-table.xml errmsgs-client.xml errmsgs-server.xml error-handling.xml extending-mysql.xml functions.xml images/blackhole-1.png images/cluster-! components-1.png images/cluster-upgrade-downgrade-table.png images/cmxj-overview.png images/cnet-win-install-step1.png images/cnet-win-install-step2.png images/cnet-win-install-step3.png images/cnet-win-install-step4.png images/cnet-win-install-step6.png images/multi-comp-1.png images/myaccess-odbc.png images/myaccess.png images/myarchitecture.png images/myflowchart.png images/myodbc-excel-step1.png images/myodbc-excel-step2.png images/myodbc-excel-step3.png images/myodbc-excel-step4.png images/myodbc-excel-step5.png images/myodbc-macosx-install-step1.png images/myodbc-macosx-install-step2.png images/myodbc-macosx-install-step3.png images/myodbc-macosx-install-step4.png images/myodbc-macosx-install-step5.png images/myodbc-macosx-install-step6.png images/myodbc-macosx-odbcadmin-adddsn.png images/myodbc-macosx-odbcadmin-main.png images/myodbc-macosx-odbcadmin-sampledsn.png images/myodbc-macosx-odbcadmin-tracing.png images/myodbc-win-install-step1.png images/myodbc-win-install! -step2.png images/myodbc-win-install-step3.png images/myodbc-w! in-insta ll-step4.png images/myodbc-win-odbcadmin-adddsn.png images/myodbc-win-odbcadmin-advanced.png images/myodbc-win-odbcadmin-driverselect.png images/myodbc-win-odbcadmin-main.png images/myodbc-win-odbcadmin-options.png images/myodbc-win-odbcadmin-sampledsn.png images/myodbc-win-tracing.png images/ndb-size-pl-1.png images/replicas-groups-1-1.png images/replicas-groups-1-2.png information-schema.xml installing.xml introduction.xml language-structure.xml legalnotice.en.xml limits.xml mysql-cluster.xml news-5.0.xml news.xml optimization.xml porting.xml precision-math.xml preface.xml problems.xml releasenotes-cs-5.0.xml releasenotes-cs.xml releasenotes-es-5.0.xml releasenotes-es.xml replication.xml reserved-new-5.0.xml reservedwords.xml restrictions.xml se-archive.xml se-bdb.xml se-blackhole.xml se-csv.xml se-example.xml se-federated.xml se-innodb.xml se-memory.xml se-merge.xml se-myisam.xml spatial-extensions.xml sql-syntax.xml storage-engines.xml stored-procedures.xml triggers.xml ! tutorial.xml using-mysql-programs.xml views.xml +MANUAL_SRCS = $(MANUAL_SRCS_EXTRA) manual.xml ../refman-common/bug-reports.xml ../refman-common/cjk-faq.en.xml ../refman-common/credits.xml ../refman-common/environment-variables.xml ../refman-common/gpl-license.xml ../refman-common/information-sources.xml ../refman-common/manual-conventions.en.xml ../refman-common/maxdb.en.xml ../refman-common/mysql-floss-license-exception.xml ../refman-common/news-cluster.xml ../refman-common/news-connector-j.xml ../refman-common/news-connector-net.xml ../refman-common/news-myodbc.xml ../refman-common/regexp.xml ../refman-common/what-is-mysql-ab.en.xml ../refman-common/what-is.en.xml apis.xml charset.xml client-utility-programs.xml connector-j.xml connector-mxj.xml connector-net.xml connector-odbc.xml connector-php.xml connectors.xml copyright.xml data-types.xml database-administration.xml dba-optvars-table.xml errmsgs-client.xml errmsgs-server.xml error-handling.xml extending-mysql.xml functions.xml images/blackhole-1.png images/cluster-! components-1.png images/cluster-upgrade-downgrade-table.png images/cmxj-overview.png images/cnet-win-install-step1.png images/cnet-win-install-step2.png images/cnet-win-install-step3.png images/cnet-win-install-step4.png images/cnet-win-install-step6.png images/multi-comp-1.png images/myaccess-odbc.png images/myaccess.png images/myarchitecture.png images/myflowchart.png images/myodbc-excel-step1.png images/myodbc-excel-step2.png images/myodbc-excel-step3.png images/myodbc-excel-step4.png images/myodbc-excel-step5.png images/myodbc-macosx-install-step1.png images/myodbc-macosx-install-step2.png images/myodbc-macosx-install-step3.png images/myodbc-macosx-install-step4.png images/myodbc-macosx-install-step5.png images/myodbc-macosx-install-step6.png images/myodbc-macosx-odbcadmin-adddsn.png images/myodbc-macosx-odbcadmin-main.png images/myodbc-macosx-odbcadmin-sampledsn.png images/myodbc-macosx-odbcadmin-tracing.png images/myodbc-win-install-step1.png images/myodbc-win-install! -step2.png images/myodbc-win-install-step3.png images/myodbc-w! in-insta ll-step4.png images/myodbc-win-odbcadmin-adddsn.png images/myodbc-win-odbcadmin-advanced.png images/myodbc-win-odbcadmin-driverselect.png images/myodbc-win-odbcadmin-main.png images/myodbc-win-odbcadmin-options.png images/myodbc-win-odbcadmin-sampledsn.png images/myodbc-win-tracing.png images/ndb-size-pl-1.png images/replicas-groups-1-1.png images/replicas-groups-1-2.png information-schema.xml installing.xml introduction.xml language-structure.xml legalnotice.en.xml limits.xml mysql-cluster.xml news-5.0.xml news.xml optimization.xml porting.xml precision-math.xml preface.xml problems.xml releasenotes-cs-5.0.xml releasenotes-cs.xml releasenotes-es-5.0.xml releasenotes-es.xml replication.xml reserved-new-5.0.xml reservedwords.xml restrictions.xml se-archive.xml se-bdb.xml se-blackhole.xml se-csv.xml se-example.xml se-federated.xml se-innodb.xml se-memory.xml se-merge.xml se-myisam.xml spatial-extensions.xml sql-syntax.xml storage-engines.xml stored-procedures.xml triggers.xml ! tutorial.xml using-mysql-programs.xml views.xml windows-config-wizard.xml manual-prepped.xml: $(MANUAL_SRCS) $(IDMAP_OBJS) manual-manprepped.xml: $(MANUAL_SRCS) $(IDMAP_OBJS) Modified: trunk/refman-5.0/installing-es.xml =================================================================== --- trunk/refman-5.0/installing-es.xml 2006-10-30 16:14:02 UTC (rev 3798) +++ trunk/refman-5.0/installing-es.xml 2006-10-30 16:34:12 UTC (rev 3799) Changed blocks: 1, Lines Added: 11, Lines Deleted: 7; 898 bytes @@ -451,16 +451,20 @@ <title>Post-install procedures</title> - <para></para> + <para>After installation....</para> + +<orderedlist> <listitem><para> + MySQL Server Configuration Wizard + </para></listitem> - <para> - MySQL Server Configuration Wizard - </para> - - <para> + <listitem><para> MySQL Network Monitoring and Advisor Service Installer - </para> + </para></listitem></orderedlist> + + <xi:include href="windows-config-wizard.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/> + + </section> <section id="installing-es-windows-upgrade"> Modified: trunk/refman-5.0/installing.xml =================================================================== --- trunk/refman-5.0/installing.xml 2006-10-30 16:14:02 UTC (rev 3798) +++ trunk/refman-5.0/installing.xml 2006-10-30 16:34:12 UTC (rev 3799) Changed blocks: 1, Lines Added: 2, Lines Deleted: 675; 26121 bytes @@ -3333,681 +3333,8 @@ </section> - <section id="windows-config-wizard" role="cs"> - - <title>Using the Configuration Wizard</title> - &cs-only; - <section id="mysql-config-wizard-introduction" role="cs"> - - <title>Introduction to the Configuration Wizard</title> - &cs-only; - - <para> - The MySQL Configuration Wizard helps automate the process of - configuring your server under Windows. The MySQL Configuration - Wizard creates a custom <filename>my.ini</filename> file by - asking you a series of questions and then applying your - responses to a template to generate a - <filename>my.ini</filename> file that is tuned to your - installation. - </para> - - <para> - The MySQL Configuration Wizard is included with the MySQL - ¤t-series; server, and is currently available for - Windows users only. - </para> - - <para> - The MySQL 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> - - <remark> - END INTRODUCTION - </remark> - - </section> - - <section id="mysql-config-wizard-starting" role="cs"> - - <title>Starting the MySQL Configuration Wizard</title> - &cs-only; - <para> - The MySQL Configuration Wizard is typically launched from the - MySQL Installation Wizard, as the MySQL Installation Wizard - exits. You can also 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> - - <remark> - END STARTING - </remark> - - </section> - - <section id="mysql-config-wizard-maintenance" role="cs"> - - <title>Choosing a Maintenance Option</title> - &cs-only; - <para> - If the MySQL Configuration Wizard detects an existing - <filename>my.ini</filename> file, you have the option of - either reconfiguring your existing server, or removing the - server instance by deleting the <filename>my.ini</filename> - 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. Your existing - <filename>my.ini</filename> file is renamed to - <filename>my<replaceable>timestamp</replaceable>.ini.bak</filename>, - where <replaceable>timestamp</replaceable> is the date and - time at which the existing <filename>my.ini</filename> file - was created. 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 Configuration - Wizard stops and removes the MySQL service, and then deletes - the <filename>my.ini</filename> 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> - - <remark> - END MAINTENANCE - </remark> - - </section> - - <section id="mysql-config-wizard-configuration-type" role="cs"> - - <title>Choosing a Configuration Type</title> - &cs-only; - <para> - When you start the MySQL 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> - - <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> - - <remark> - END STANDARD CONFIGURATION - </remark> - - <remark> - END CHOOSING TYPE - </remark> - - </section> - - <section id="mysql-config-wizard-server-type" role="cs"> - - <title>The Server Type Dialog</title> - &cs-only; - <para> - There are three different server types available to choose - from. The server type that you choose affects the decisions - that the MySQL Configuration Wizard makes with regard to - memory, disk, and processor usage. - </para> - - <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> - - <remark> - END SERVER TYPE - </remark> - - </section> - - <section id="mysql-config-wizard-database-usage" role="cs"> - - <title>The Database Usage Dialog</title> - &cs-only; - <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> - - <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> - - <remark> - END DATABASE USAGE - </remark> - - </section> - - <section id="mysql-config-wizard-tablespace" role="cs"> - - <title>The InnoDB Tablespace Dialog</title> - &cs-only; - <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> - - <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> - - <remark> - END TABLESPACE DIALOG - </remark> - - </section> - - <section id="mysql-config-wizard-connections" role="cs"> - - <title>The Concurrent Connections Dialog</title> - &cs-only; - <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> - - <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> - - <remark> - END CONCURRENT CONNECTIONS - </remark> - - </section> - - <section id="mysql-config-wizard-networking" role="cs"> - - <title>The Networking and Strict Mode Options Dialog</title> - &cs-only; - <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> - - <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> - - <remark> - END NETWORKING AND STRICT MODE OPTIONS - </remark> - - </section> - - <section id="mysql-config-wizard-character-set" role="cs"> - - <title>The Character Set Dialog</title> - &cs-only; - <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> - - <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> - - <remark> - END CHARACTER SET - </remark> - - </section> - - <section id="mysql-config-wizard-service" role="cs"> - - <title>The Service Options Dialog</title> - &cs-only; - <para> - On Windows NT-based 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 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> - - <remark> - END SERVICE OPTIONS - </remark> - - </section> - - <section id="mysql-config-wizard-security" role="cs"> - - <title>The Security Options Dialog</title> - &cs-only; - <para> - <emphasis>It is strongly recommended that you set a - <literal>root</literal> password for your MySQL - server</emphasis>, and the MySQL 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> - - <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> - 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> - - <remark> - END SECURITY OPTIONS - </remark> - - </section> - - <section id="mysql-config-wizard-confirmation" role="cs"> - - <title>The Confirmation Dialog</title> - &cs-only; - <para> - The final dialog in the MySQL 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 Configuration Wizard without configuring the server, - click the <guibutton>Cancel</guibutton> button. - </para> - - <para> - After you click the <guibutton>Execute</guibutton> button, the - MySQL Configuration Wizard performs a series of tasks and - displays the progress onscreen as the tasks are performed. - </para> - - <para> - The MySQL 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 a - <filename>my.ini</filename> file. The final location of the - <filename>my.ini</filename> file is displayed next to the - <guilabel>Write configuration file</guilabel> task. - </para> - - <para> - If you chose to create a service for the MySQL server, the - MySQL Configuration Wizard creates and starts the service. If - you are reconfiguring an existing service, the MySQL - 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 Configuration Wizard has completed its tasks, - it displays a summary. Click the <guibutton>Finish</guibutton> - button to exit the MySQL Configuration Wizard. - </para> - - <remark> - END CONFIRMATION DIALOG - </remark> - - </section> - - <section id="mysql-config-wizard-file-location" role="cs"> - - <title>The Location of the my.ini File</title> - &cs-only; - <para> - The MySQL 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 ¤t-series;</replaceable>\my.ini" -</programlisting> - - <para> - Here, <replaceable>C:\Program Files\MySQL\MySQL Server - ¤t-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> - - <remark> - END INI FILE LOCTAION - </remark> - - </section> - - <section id="mysql-config-wizard-editing" role="cs"> - - <title>Editing the my.ini File</title> - &cs-only; - <para> - To modify the <filename>my.ini</filename> file, open it with a - text editor and make any necessary changes. You can also - modify the server configuration with the - <ulink url="http://www.mysql.com/products/administrator/">MySQL - Administrator</ulink> utility. - </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 <filename>C:\WINDOWS</filename> or - <filename>C:\WINNT</filename> directory (whichever is - applicable to your Windows version). - </para> - - </section> - - </section> - + <xi:include href="windows-config-wizard.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/> + <section id="windows-install-archive" role="cs"> <title>Installing MySQL from a Noinstall Zip Archive</title> Added: trunk/refman-5.0/windows-config-wizard.xml =================================================================== --- trunk/refman-5.0/windows-config-wizard.xml (rev 0) +++ trunk/refman-5.0/windows-config-wizard.xml 2006-10-30 16:34:12 UTC (rev 3799) Changed blocks: 1, Lines Added: 689, Lines Deleted: 0; 26316 bytes @@ -0,0 +1,689 @@ +<?xml version="1.0" encoding="utf-8"?> +<!DOCTYPE section PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN" +"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd" +[ + <!ENTITY % fixedchars.entities SYSTEM "../refman-common/fixedchars.ent"> + %fixedchars.entities; + <!ENTITY % urls.entities SYSTEM "../refman-common/urls.ent"> + %urls.entities; + <!ENTITY % phrases.entities SYSTEM "../refman-common/phrases.ent"> + %phrases.entities; + <!ENTITY % versions.entities SYSTEM "versions.ent"> + %versions.entities; +]> + <section id="windows-config-wizard" role="cses"> + + <title>Using the Configuration Wizard</title> + + <section id="mysql-config-wizard-introduction" role="cses"> + + <title>Introduction to the Configuration Wizard</title> + + + <para> + The MySQL Configuration Wizard helps automate the process of + configuring your server under Windows. The MySQL Configuration + Wizard creates a custom <filename>my.ini</filename> file by + asking you a series of questions and then applying your + responses to a template to generate a + <filename>my.ini</filename> file that is tuned to your + installation. + </para> + + <para> + The MySQL Configuration Wizard is included with the MySQL + ¤t-series; server, and is currently available for + Windows users only. + </para> + + <para> + The MySQL 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> + + <remark> + END INTRODUCTION + </remark> + + </section> + + <section id="mysql-config-wizard-starting" role="cses"> + + <title>Starting the MySQL Configuration Wizard</title> + + <para> + The MySQL Configuration Wizard is typically launched from the + MySQL Installation Wizard, as the MySQL Installation Wizard + exits. You can also 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> + + <remark> + END STARTING + </remark> + + </section> + + <section id="mysql-config-wizard-maintenance" role="cses"> + + <title>Choosing a Maintenance Option</title> + + <para> + If the MySQL Configuration Wizard detects an existing + <filename>my.ini</filename> file, you have the option of + either reconfiguring your existing server, or removing the + server instance by deleting the <filename>my.ini</filename> + 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. Your existing + <filename>my.ini</filename> file is renamed to + <filename>my<replaceable>timestamp</replaceable>.ini.bak</filename>, + where <replaceable>timestamp</replaceable> is the date and + time at which the existing <filename>my.ini</filename> file + was created. 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 Configuration + Wizard stops and removes the MySQL service, and then deletes + the <filename>my.ini</filename> 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> + + <remark> + END MAINTENANCE + </remark> + + </section> + + <section id="mysql-config-wizard-configuration-type" role="cses"> + + <title>Choosing a Configuration Type</title> + + <para> + When you start the MySQL 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> + + <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> + + <remark> + END STANDARD CONFIGURATION + </remark> + + <remark> + END CHOOSING TYPE + </remark> + + </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 Configuration Wizard makes with regard to + memory, disk, and processor usage. + </para> + + <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> + + <remark> + END SERVER TYPE + </remark> + + </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> + + <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> + + <remark> + END DATABASE USAGE + </remark> + + </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> + + <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> + + <remark> + END TABLESPACE DIALOG + </remark> + + </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> + + <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> + + <remark> + END CONCURRENT CONNECTIONS + </remark> + + </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> + + <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> + + <remark> + END NETWORKING AND STRICT MODE OPTIONS + </remark> + + </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> + + <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> + + <remark> + END CHARACTER SET + </remark> + + </section> + + <section id="mysql-config-wizard-service" role="cses"> + + <title>The Service Options Dialog</title> + + <para> + On Windows NT-based 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 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> + + <remark> + END SERVICE OPTIONS + </remark> + + </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 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> + + <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> + 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> + + <remark> + END SECURITY OPTIONS + </remark> + + </section> + + <section id="mysql-config-wizard-confirmation" role="cses"> + + <title>The Confirmation Dialog</title> + + <para> + The final dialog in the MySQL 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 Configuration Wizard without configuring the server, + click the <guibutton>Cancel</guibutton> button. + </para> + + <para> + After you click the <guibutton>Execute</guibutton> button, the + MySQL Configuration Wizard performs a series of tasks and + displays the progress onscreen as the tasks are performed. + </para> + + <para> + The MySQL 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 a + <filename>my.ini</filename> file. The final location of the + <filename>my.ini</filename> file is displayed next to the + <guilabel>Write configuration file</guilabel> task. + </para> + + <para> + If you chose to create a service for the MySQL server, the + MySQL Configuration Wizard creates and starts the service. If + you are reconfiguring an existing service, the MySQL + 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 Configuration Wizard has completed its tasks, + it displays a summary. Click the <guibutton>Finish</guibutton> + button to exit the MySQL Configuration Wizard. + </para> + + <remark> + END CONFIRMATION DIALOG + </remark> + + </section> + + <section id="mysql-config-wizard-file-location" role="cses"> + + <title>The Location of the my.ini File</title> + + <para> + The MySQL 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 ¤t-series;</replaceable>\my.ini" +</programlisting> + + <para> + Here, <replaceable>C:\Program Files\MySQL\MySQL Server + ¤t-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> + + <remark> + END INI FILE LOCTAION + </remark> + + </section> + + <section id="mysql-config-wizard-editing" role="cses"> + + <title>Editing the my.ini File</title> + + <para> + To modify the <filename>my.ini</filename> file, open it with a + text editor and make any necessary changes. You can also + modify the server configuration with the + <ulink url="http://www.mysql.com/products/administrator/">MySQL + Administrator</ulink> utility. + </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 <filename>C:\WINDOWS</filename> or + <filename>C:\WINNT</filename> directory (whichever is + applicable to your Windows version). + </para> + + </section> + + </section> + +
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r3799 - trunk/refman-5.0 | mcbrown | 30 Oct |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 1.136 sec. using MySQL 5.1.14-beta-log