Author: mcbrown
Date: 2008-04-28 12:48:15 +0200 (Mon, 28 Apr 2008)
New Revision: 10599
Log:
Documenting Dev Bug #34593
Fixing some issues and inconsistencies in the Windows install notes
Adding upgrade notes and warnings for the location changes
Removing some remarks that have been resolved or that are no longer needed
Fixing our supported list to correct citations and all current Windows releases from 2000 to 2008
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/refman-5.1/installing-core.xml
trunk/refman-6.0/installing-core.xml
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-04-27 13:17:03 UTC (rev 10598)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-04-28 10:48:15 UTC (rev 10599)
Changed blocks: 2, Lines Added: 58, Lines Deleted: 4; 2627 bytes
@@ -9,6 +9,64 @@
<logentry entrytype="bug">
<tags>
+ <manual type="Windows"/>
+ <highlight type="importantchange"/>
+ <highlight type="securityenhancement"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="34593"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ On Windows Vista and Windows Server 2008, a user without
+ administrative privileges does not have write permissions to the
+ <filename>Program Files</filename> directory where MySQL and the
+ associated data files are normally installed. Using data files
+ located in the standard <filename>Program Files</filename>
+ installation directory could therefore cause MySQL to fail, or
+ lead to potential security issues in an installed instance.
+ </para>
+
+ <para>
+ To address the problem, on Windows XP, Windows Vista and Windows
+ Server 2008, the datafiles and data file configuration are now
+ set to the Microsoft recommended <filename>AppData</filename>
+ folder. The <filename>AppData</filename> folder is typically
+ located within the user's home directory.
+ </para>
+
+ <important>
+ <para>
+ When upgrading an existing 5.1.23 or 6.0.4 installation of
+ MySQL you must take a backup of your data before installing
+ the new version. To migrate your data, either extract the data
+ and reimport (using <command>mysqldump</command>, then upgrade
+ and re-import using <command>mysql</command>), or backup your
+ data, upgrade to the new version, and copy your existing data
+ files from your old <filename>datadir</filename> directory to
+ the new directory located within <filename>AppData</filename>.
+ </para>
+ <para>
+ Failure to backup your data and follow these procedures may
+ lead to data loss.
+ </para>
+ </important>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
<highlight type="cluster"/>
<manual type="error 1427"/>
</tags>
@@ -16903,10 +16961,6 @@
<manual type="report_user"/>
</tags>
- <bugs>
- <fixes bugid="XXX"/>
- </bugs>
-
<versions>
<version ver="5.1.24"/>
<version ver="6.0.5"/>
Modified: trunk/refman-5.1/installing-core.xml
===================================================================
--- trunk/refman-5.1/installing-core.xml 2008-04-27 13:17:03 UTC (rev 10598)
+++ trunk/refman-5.1/installing-core.xml 2008-04-28 10:48:15 UTC (rev 10599)
Changed blocks: 31, Lines Added: 55, Lines Deleted: 133; 11445 bytes
@@ -355,7 +355,8 @@
<listitem>
<para>
- Windows 2000, XP, and Windows Server 2003. See
+ Windows 2000, Windows XP, Windows Vista, Windows Server
+ 2003, and Windows Server 2008. See
<xref linkend="windows-installation"/>.
</para>
</listitem>
@@ -2560,11 +2561,6 @@
<title>Installing MySQL on Windows</title>
- <remark role="todo">
- The prompt is inconsistent in the Windows sections. Sometimes it
- begins with C:, sometimes it's shell>.
- </remark>
-
<para>
A native Windows distribution of MySQL has been available from
MySQL AB since version 3.21 and represents a sizable percentage of
@@ -2588,8 +2584,9 @@
<listitem>
<para>
- A 32-bit Windows operating system such as 2000, XP, Vista, or
- Windows Server 2003.
+ A 32-bit Windows operating system, including Windows 2000,
+ Windows XP, Windows Vista, Windows Server 2003, and Windows
+ Server 2008.
</para>
<para>
@@ -2602,7 +2599,9 @@
account that has administrator rights. Otherwise, you may
encounter problems with certain operations such as editing the
<literal>PATH</literal> environment variable or accessing the
- <command>Service Control Manager</command>.
+ <command>Service Control Manager</command>. Once installed,
+ MySQL does not need to be executed using a user with
+ Administrator privileges.
</para>
</listitem>
@@ -2637,12 +2636,21 @@
<listitem>
<para>
If you plan to connect to the MySQL server via ODBC, you need
- a Connector/ODBC driver. See <xref linkend="connectors"/>.
+ a Connector/ODBC driver. See
+ <xref linkend="myodbc-connector"/>.
</para>
</listitem>
<listitem>
<para>
+ If you plan to use MySQL server with ADO.NET applications, you
+ need the Connector/NET driver. See
+ <xref linkend="connector-net"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
If you need tables with a size larger than 4GB, install MySQL
on an NTFS or newer filesystem. Don't forget to use
<literal>MAX_ROWS</literal> and
@@ -2672,11 +2680,6 @@
<listitem>
<para>
- <remark role="todo">
- This is changing to VS.NET. Determine which versions the
- change will affect. [js]
- </remark>
-
The source distribution contains all the code and support
files for building the executables using the Visual Studio
compiler system.
@@ -2863,11 +2866,6 @@
<xref linkend="bug-reports"/>.
</para>
- <remark role="note">
- - "install" is a verb. - "installation" is a noun. - "install"
- is NOT a noun, it's a verb. Thank you. /JS
- </remark>
-
</section>
<section id="mysql-install-wizard-starting">
@@ -2916,10 +2914,6 @@
start the installation process.
</para>
- <remark>
- END STARTING
- </remark>
-
</section>
<section id="mysql-install-wizard-install-type">
@@ -2970,10 +2964,6 @@
<xref linkend="mysql-install-wizard-custom-install"/>.
</para>
- <remark>
- END INSTALLATION TYPES
- </remark>
-
</section>
<section id="mysql-install-wizard-custom-install">
@@ -3008,10 +2998,6 @@
to the confirmation dialog.
</para>
- <remark>
- END CUSTOM INSTALLATION
- </remark>
-
</section>
<section id="mysql-install-wizard-confirmation-dialog">
@@ -3047,10 +3033,6 @@
service, and configure security settings.
</para>
- <remark>
- END CONFIRMATION DIALOG
- </remark>
-
</section>
<section id="mysql-install-wizard-changes">
@@ -3099,10 +3081,6 @@
are not created.
</para>
- <remark>
- END REGISTRY
- </remark>
-
<para>
<emphasis role="bold">Changes to the Start Menu</emphasis>
</para>
@@ -3156,14 +3134,6 @@
</itemizedlist>
- <remark>
- [MH] Once again, if the package names change update this!
- </remark>
-
- <remark>
- END START MENU
- </remark>
-
<para>
<emphasis role="bold">Changes to the File System</emphasis>
</para>
@@ -3202,14 +3172,15 @@
applications installed on a particular system.
</para>
- <remark>
- END FILE SYSTEM CHANGES
- </remark>
+ <para>
+ In MySQL 5.1.23 and earlier, the default location for the data
+ files used by MySQL is located within the corresponding MySQL
+ Server installation directory. For MySQL 5.1.24 and later, the
+ default location of the data directory is the
+ <filename>AppData</filename> directory configured for the user
+ that installed the MySQL application.
+ </para>
- <remark>
- END CHANGES
- </remark>
-
</section>
<section id="mysql-install-wizard-upgrading">
@@ -3237,10 +3208,6 @@
See <xref linkend="windows-upgrading"/>.
</para>
- <remark>
- END UPGRADING
- </remark>
-
</section>
</section>
@@ -3278,10 +3245,6 @@
<xref linkend="bug-reports"/>.
</para>
- <remark>
- END INTRODUCTION
- </remark>
-
</section>
<section id="mysql-config-wizard-starting">
@@ -3322,10 +3285,6 @@
</para>
</note>
- <remark>
- END STARTING
- </remark>
-
</section>
<section id="mysql-config-wizard-maintenance">
@@ -3369,10 +3328,6 @@
choose the type of installation that you wish to configure.
</para>
- <remark>
- END MAINTENANCE
- </remark>
-
</section>
<section id="mysql-config-wizard-configuration-type">
@@ -3429,14 +3384,6 @@
<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">
@@ -3496,10 +3443,6 @@
</para>
</note>
- <remark>
- END SERVER TYPE
- </remark>
-
</section>
<section id="mysql-config-wizard-database-usage">
@@ -3625,10 +3568,6 @@
starting the server.
</para>
- <remark>
- END TABLESPACE DIALOG
- </remark>
-
</section>
<section id="mysql-config-wizard-connections">
@@ -3679,10 +3618,6 @@
</itemizedlist>
- <remark>
- END CONCURRENT CONNECTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-networking">
@@ -3720,10 +3655,6 @@
<xref linkend="server-sql-mode"/>.
</para>
- <remark>
- END NETWORKING AND STRICT MODE OPTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-character-set">
@@ -3772,10 +3703,6 @@
</itemizedlist>
- <remark>
- END CHARACTER SET
- </remark>
-
</section>
<section id="mysql-config-wizard-service">
@@ -3808,10 +3735,6 @@
Automatically</guimenuitem> option.
</para>
- <remark>
- END SERVICE OPTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-security">
@@ -3851,10 +3774,6 @@
is not recommended.
</para>
- <remark>
- END SECURITY OPTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-confirmation">
@@ -3913,10 +3832,6 @@
button to exit the MySQL Configuration Wizard.
</para>
- <remark>
- END CONFIRMATION DIALOG
- </remark>
-
</section>
<section id="mysql-config-wizard-file-location">
@@ -3950,10 +3865,6 @@
when it starts.
</para>
- <remark>
- END INI FILE LOCTAION
- </remark>
-
</section>
<section id="mysql-config-wizard-editing">
@@ -4112,12 +4023,9 @@
</listitem>
<listitem>
- <remark role="todo">
- Add an example here.
- </remark>
-
<para>
- You need to tune the server settings.
+ You need to tune the server settings, such as memory, cache,
+ or InnoDB configuration information.
</para>
</listitem>
@@ -4199,26 +4107,29 @@
</formalpara>
<para>
- On Windows, the MySQL installer places the data directory
- directly under the directory where you install MySQL. If you
- would like to use a data directory in a different location, you
- should copy the entire contents of the <filename>data</filename>
- directory to the new location. For example, if MySQL is
- installed in <filename>C:\Program Files\MySQL\MySQL Server
- ¤t-series;</filename>, the data directory is by default in
- <filename>C:\Program Files\MySQL\MySQL Server
- ¤t-series;\data</filename>. If you want to use
- <filename>E:\mydata</filename> as the data directory instead,
- you must do two things:
+ In MySQL 5.1.23 and earlier, the MySQL installer places the data
+ directory directly under the directory where you install MySQL.
+ On MySQL 5.1.24 and later, the data directory is located within
+ the <filename>AppData</filename> directory for the user running
+ MySQL.
</para>
+ <para>
+ If you would like to use a data directory in a different
+ location, you should copy the entire contents of the
+ <filename>data</filename> directory to the new location. For
+ example, if you want to use <filename>E:\mydata</filename> as
+ the data directory instead, you must do two things:
+ </para>
+
<orderedlist>
<listitem>
<para>
Move the entire <filename>data</filename> directory and all
- of its contents from <filename>C:\Program Files\MySQL\MySQL
- Server ¤t-series;\data</filename> to
+ of its contents from the default location (for example
+ <filename>C:\Program Files\MySQL\MySQL Server
+ ¤t-series;\data</filename>) to
<filename>E:\mydata</filename>.
</para>
</listitem>
@@ -5233,6 +5144,17 @@
<listitem>
<para>
+ When upgrading from MySQL 5.1.23 to MySQL 5.1.24, the change
+ in the default location of the data directory from a
+ directory within the MySQL installation to the
+ <filename>AppData</filename> folder means that you must
+ manually copy the data files from your old installation to
+ the new location.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
If you are using the MySQL Installation Wizard, start the
wizard as described in
<xref linkend="windows-install-wizard"/>.
Modified: trunk/refman-6.0/installing-core.xml
===================================================================
--- trunk/refman-6.0/installing-core.xml 2008-04-27 13:17:03 UTC (rev 10598)
+++ trunk/refman-6.0/installing-core.xml 2008-04-28 10:48:15 UTC (rev 10599)
Changed blocks: 32, Lines Added: 56, Lines Deleted: 157; 12535 bytes
@@ -355,7 +355,8 @@
<listitem>
<para>
- Windows 2000, XP, and Windows Server 2003. See
+ Windows 2000, Windows XP, Windows Vista, Windows Server
+ 2003, and Windows Server 2008. See
<xref linkend="windows-installation"/>.
</para>
</listitem>
@@ -2570,11 +2571,6 @@
<title>Installing MySQL on Windows</title>
- <remark role="todo">
- The prompt is inconsistent in the Windows sections. Sometimes it
- begins with C:, sometimes it's shell>.
- </remark>
-
<para>
A native Windows distribution of MySQL has been available from
MySQL AB since version 3.21 and represents a sizable percentage of
@@ -2598,8 +2594,9 @@
<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 Windows 2000,
+ Windows XP, Windows Vista, Windows Server 2003, or Windows
+ Server 2008.
</para>
<para>
@@ -2612,7 +2609,9 @@
account that has administrator rights. Otherwise, you may
encounter problems with certain operations such as editing the
<literal>PATH</literal> environment variable or accessing the
- <command>Service Control Manager</command>.
+ <command>Service Control Manager</command>. Once installed,
+ MySQL does not need to be executed using a user with Admin
+ istrator privileges.
</para>
</listitem>
@@ -2647,12 +2646,21 @@
<listitem>
<para>
If you plan to connect to the MySQL server via ODBC, you need
- a Connector/ODBC driver. See <xref linkend="connectors"/>.
+ a Connector/ODBC driver. See
+ <xref linkend="myodbc-connector"/>.
</para>
</listitem>
<listitem>
<para>
+ If you plan to use MySQL server with ADO.NET applications, you
+ need the Connector/NET driver. See
+ <xref linkend="connector-net"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
If you need tables with a size larger than 4GB, install MySQL
on an NTFS or newer filesystem. Don't forget to use
<literal>MAX_ROWS</literal> and
@@ -2682,11 +2690,6 @@
<listitem>
<para>
- <remark role="todo">
- This is changing to VS.NET. Determine which versions the
- change will affect. [js]
- </remark>
-
The source distribution contains all the code and support
files for building the executables using the Visual Studio
compiler system.
@@ -2873,11 +2876,6 @@
<xref linkend="bug-reports"/>.
</para>
- <remark role="note">
- - "install" is a verb. - "installation" is a noun. - "install"
- is NOT a noun, it's a verb. Thank you. /JS
- </remark>
-
</section>
<section id="mysql-install-wizard-starting">
@@ -2926,10 +2924,6 @@
start the installation process.
</para>
- <remark>
- END STARTING
- </remark>
-
</section>
<section id="mysql-install-wizard-install-type">
@@ -2980,10 +2974,6 @@
<xref linkend="mysql-install-wizard-custom-install"/>.
</para>
- <remark>
- END INSTALLATION TYPES
- </remark>
-
</section>
<section id="mysql-install-wizard-custom-install">
@@ -3018,10 +3008,6 @@
to the confirmation dialog.
</para>
- <remark>
- END CUSTOM INSTALLATION
- </remark>
-
</section>
<section id="mysql-install-wizard-confirmation-dialog">
@@ -3056,11 +3042,8 @@
can use to create a configuration file, install the MySQL
service, and configure security settings.
</para>
+>
- <remark>
- END CONFIRMATION DIALOG
- </remark>
-
</section>
<section id="mysql-install-wizard-changes">
@@ -3109,10 +3092,6 @@
are not created.
</para>
- <remark>
- END REGISTRY
- </remark>
-
<para>
<emphasis role="bold">Changes to the Start Menu</emphasis>
</para>
@@ -3166,14 +3145,6 @@
</itemizedlist>
- <remark>
- [MH] Once again, if the package names change update this!
- </remark>
-
- <remark>
- END START MENU
- </remark>
-
<para>
<emphasis role="bold">Changes to the File System</emphasis>
</para>
@@ -3212,14 +3183,15 @@
applications installed on a particular system.
</para>
- <remark>
- END FILE SYSTEM CHANGES
- </remark>
+ <para>
+ In MySQL 5.1.23 and earlier, the default location for the data
+ files used by MySQL is located within the corresponding MySQL
+ Server installation directory. For MySQL 5.1.24 and later, the
+ default location of the data directory is the
+ <filename>AppData</filename> directory configured for the user
+ that installed the MySQL application.
+ </para>
- <remark>
- END CHANGES
- </remark>
-
</section>
<section id="mysql-install-wizard-upgrading">
@@ -3247,10 +3219,6 @@
See <xref linkend="windows-upgrading"/>.
</para>
- <remark>
- END UPGRADING
- </remark>
-
</section>
</section>
@@ -3288,10 +3256,6 @@
<xref linkend="bug-reports"/>.
</para>
- <remark>
- END INTRODUCTION
- </remark>
-
</section>
<section id="mysql-config-wizard-starting">
@@ -3332,10 +3296,6 @@
</para>
</note>
- <remark>
- END STARTING
- </remark>
-
</section>
<section id="mysql-config-wizard-maintenance">
@@ -3379,10 +3339,6 @@
choose the type of installation that you wish to configure.
</para>
- <remark>
- END MAINTENANCE
- </remark>
-
</section>
<section id="mysql-config-wizard-configuration-type">
@@ -3439,14 +3395,6 @@
<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">
@@ -3506,10 +3454,6 @@
</para>
</note>
- <remark>
- END SERVER TYPE
- </remark>
-
</section>
<section id="mysql-config-wizard-database-usage">
@@ -3635,10 +3579,6 @@
starting the server.
</para>
- <remark>
- END TABLESPACE DIALOG
- </remark>
-
</section>
<section id="mysql-config-wizard-connections">
@@ -3689,10 +3629,6 @@
</itemizedlist>
- <remark>
- END CONCURRENT CONNECTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-networking">
@@ -3730,10 +3666,6 @@
<xref linkend="server-sql-mode"/>.
</para>
- <remark>
- END NETWORKING AND STRICT MODE OPTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-character-set">
@@ -3782,10 +3714,6 @@
</itemizedlist>
- <remark>
- END CHARACTER SET
- </remark>
-
</section>
<section id="mysql-config-wizard-service">
@@ -3818,10 +3746,6 @@
Automatically</guimenuitem> option.
</para>
- <remark>
- END SERVICE OPTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-security">
@@ -3861,10 +3785,6 @@
is not recommended.
</para>
- <remark>
- END SECURITY OPTIONS
- </remark>
-
</section>
<section id="mysql-config-wizard-confirmation">
@@ -3923,10 +3843,6 @@
button to exit the MySQL Configuration Wizard.
</para>
- <remark>
- END CONFIRMATION DIALOG
- </remark>
-
</section>
<section id="mysql-config-wizard-file-location">
@@ -3960,10 +3876,6 @@
when it starts.
</para>
- <remark>
- END INI FILE LOCTAION
- </remark>
-
</section>
<section id="mysql-config-wizard-editing">
@@ -4127,7 +4039,8 @@
</remark>
<para>
- You need to tune the server settings.
+ You need to tune the server settings, such as memory, cache,
+ or InnoDB configuration information.
</para>
</listitem>
@@ -4209,26 +4122,29 @@
</formalpara>
<para>
- On Windows, the MySQL installer places the data directory
- directly under the directory where you install MySQL. If you
- would like to use a data directory in a different location, you
- should copy the entire contents of the <filename>data</filename>
- directory to the new location. For example, if MySQL is
- installed in <filename>C:\Program Files\MySQL\MySQL Server
- ¤t-series;</filename>, the data directory is by default in
- <filename>C:\Program Files\MySQL\MySQL Server
- ¤t-series;\data</filename>. If you want to use
- <filename>E:\mydata</filename> as the data directory instead,
- you must do two things:
+ In MySQL 5.1.23 and earlier, the MySQL installer places the data
+ directory directly under the directory where you install MySQL.
+ On MySQL 5.1.24 and later, the data directory is located within
+ the <filename>AppData</filename> directory for the user running
+ MySQL.
</para>
+ <para>
+ If you would like to use a data directory in a different
+ location, you should copy the entire contents of the
+ <filename>data</filename> directory to the new location. For
+ example, if you want to use <filename>E:\mydata</filename> as
+ the data directory instead, you must do two things:
+ </para>
+
<orderedlist>
<listitem>
<para>
Move the entire <filename>data</filename> directory and all
- of its contents from <filename>C:\Program Files\MySQL\MySQL
- Server ¤t-series;\data</filename> to
+ of its contents from the default location (for example
+ <filename>C:\Program Files\MySQL\MySQL Server
+ ¤t-series;\data</filename>) to
<filename>E:\mydata</filename>.
</para>
</listitem>
@@ -5181,6 +5097,17 @@
<listitem>
<para>
+ When upgrading from MySQL 5.1.23 to MySQL 5.1.24, the change
+ in the default location of the data directory from a
+ directory within the MySQL installation to the
+ <filename>AppData</filename> folder means that you must
+ manually copy the data files from your old installation to
+ the new location.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
If you are using the MySQL Installation Wizard, start the
wizard as described in
<xref linkend="windows-install-wizard"/>.
@@ -10043,34 +9970,6 @@
</section>
- <section id="borland-c-plus-plus">
-
- <title>Building MySQL from Source Using Borland C++</title>
-
- <indexterm>
- <primary>Borland C++ compiler</primary>
- </indexterm>
-
- <para>
- You can compile the MySQL Windows source with Borland C++
- 5.02. (The Windows source includes only projects for Microsoft
- VC++, for Borland C++ you have to do the project files
- yourself.)
- </para>
-
- <para>
- One known problem with Borland C++ is that it uses a different
- structure alignment than VC++. This means that you run into
- problems if you try to use the default
- <literal>libmysql.dll</literal> libraries (that were compiled
- using VC++) with Borland C++. To avoid this problem, only call
- <function role="capi">mysql_init()</function> with
- <literal>NULL</literal> as an argument, not a pre-allocated
- <literal>MYSQL</literal> structure.
- </para>
-
- </section>
-
</section>
<section id="windows-client-compiling">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10599 - in trunk: dynamic-docs/changelog refman-5.1 refman-6.0 | mcbrown | 28 Apr |
