Author: plavin
Date: 2007-08-09 19:36:23 +0200 (Thu, 09 Aug 2007)
New Revision: 7396
Log:
Add notes baout using Vista with the installation wizard
Modified:
trunk/refman-4.1/installing.xml
trunk/refman-5.0/Makefile.depends
trunk/refman-5.0/config-wizard.xml
trunk/refman-5.0/installing-cs.xml
trunk/refman-5.1/installing.xml
trunk/userguide/php-pdo.xml
Modified: trunk/refman-4.1/installing.xml
===================================================================
--- trunk/refman-4.1/installing.xml 2007-08-09 17:33:52 UTC (rev 7395)
+++ trunk/refman-4.1/installing.xml 2007-08-09 17:36:23 UTC (rev 7396)
Changed blocks: 2, Lines Added: 40, Lines Deleted: 1; 2946 bytes
@@ -2859,6 +2859,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.
+ </para>
+ </note>
<para>
The process for starting the wizard depends on the contents of
@@ -3267,7 +3291,22 @@
and launch the <filename>MySQLInstanceConfig.exe</filename>
file directly.
</para>
-
+
+ <note>
+ <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
+ a program that bypasses the Windows Firewall.
+ One or the other option is sufficient — 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>
+ </note>
+
<remark>
END STARTING
</remark>
Modified: trunk/refman-5.0/Makefile.depends
===================================================================
--- trunk/refman-5.0/Makefile.depends 2007-08-09 17:33:52 UTC (rev 7395)
+++ trunk/refman-5.0/Makefile.depends 2007-08-09 17:36:23 UTC (rev 7396)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 640 bytes
@@ -141,7 +141,8 @@
config_wizard_SOURCES = config-wizard.xml $(config_wizard_INCLUDES)
config_wizard_IDMAPS = \
../refman-common/metadata/bug-reports.idmap \
- metadata/dba-core.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)
Modified: trunk/refman-5.0/config-wizard.xml
===================================================================
--- trunk/refman-5.0/config-wizard.xml 2007-08-09 17:33:52 UTC (rev 7395)
+++ trunk/refman-5.0/config-wizard.xml 2007-08-09 17:36:23 UTC (rev 7396)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 0; 1217 bytes
@@ -43,6 +43,19 @@
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
+ a program that bypasses the Windows Firewall.
+ One or the other option is sufficient — 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>
Modified: trunk/refman-5.0/installing-cs.xml
===================================================================
--- trunk/refman-5.0/installing-cs.xml 2007-08-09 17:33:52 UTC (rev 7395)
+++ trunk/refman-5.0/installing-cs.xml 2007-08-09 17:36:23 UTC (rev 7396)
Changed blocks: 1, Lines Added: 24, Lines Deleted: 0; 1917 bytes
@@ -2764,6 +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.
+ </para>
+ </note>
<para>
The process for starting the wizard depends on the contents of
Modified: trunk/refman-5.1/installing.xml
===================================================================
--- trunk/refman-5.1/installing.xml 2007-08-09 17:33:52 UTC (rev 7395)
+++ trunk/refman-5.1/installing.xml 2007-08-09 17:36:23 UTC (rev 7396)
Changed blocks: 2, Lines Added: 49, Lines Deleted: 1; 3695 bytes
@@ -2872,6 +2872,39 @@
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.
+ </para>
+
+ <para>
+ If you choose not to open a port prior to installing MySQL on Windows Vista,
+ you can use the MySQL Server Configuration Wizard after installation.
+ However, you must open a port in the Windows Firewall.
+ Once MySQL is installed, you also have the option of adding
+ a program that bypasses the Windows Firewall.
+ One or the other option is sufficient — you need not do both.
+ </para>
+ </note>
<para>
The process for starting the wizard depends on the contents of
@@ -3263,13 +3296,28 @@
<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>
+
+ <note>
+ <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
+ a program that bypasses the Windows Firewall.
+ One or the other option is sufficient — 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>
+ </note>
<remark>
END STARTING
Modified: trunk/userguide/php-pdo.xml
===================================================================
--- trunk/userguide/php-pdo.xml 2007-08-09 17:33:52 UTC (rev 7395)
+++ trunk/userguide/php-pdo.xml 2007-08-09 17:36:23 UTC (rev 7396)
Changed blocks: 5, Lines Added: 38, Lines Deleted: 43; 5672 bytes
@@ -21,9 +21,9 @@
can provide advantages; you can use the same data-access methods
regardless of the MySQL version. This does away with the need for
using the standard MySQL extension with older versions of MySQL
- and using the MySQLi extension for later versions. An additional advantage,
- is the ability to use object-oriented code regardless of the version of
- MySQL.
+ and using the MySQLi extension for later versions. An additional
+ advantage is the ability to use object-oriented code regardless
+ of the version of MySQL.
</para>
<para>
@@ -38,12 +38,12 @@
your exact specifications and ensure that you have not only PDO
but also the drivers you need. However, the package managers of
most current Linux distributions make it easy to add
- support—if it's not already there. Under Ubuntu (feisty
- fawn) and openSuSE (10.2) the <literal>php5-pdo</literal> module
- provides support for PDO and the <literal>php5-mysql</literal>
- module provides the PDO driver for MySQL. If you are already using
- MySQL with PHP you already have the PDO driver. You only need
- check that you have the PDO module loaded.
+ support—if it's not already there. Under openSuSE (10.2) for
+ instance, the <literal>php5-pdo</literal> module provides support
+ for PDO and the <literal>php5-mysql</literal> module provides the
+ PDO driver for MySQL. If you are already using MySQL with PHP you
+ already have the PDO driver. You only need check that you have the
+ PDO module loaded.
</para>
<para>
@@ -62,27 +62,23 @@
<section id="project-outline">
<title>Project Outline</title>
-
+
<para>
- The PDO extension is entirely object-oriented,
- there is no procedural version of this extension,
- so some knowledge of object-oriented programming is
- assumed.
+ The PDO extension is entirely object-oriented, there is no
+ procedural version of this extension, so some knowledge of
+ object-oriented programming is assumed.
</para>
<para>
- The project examined in this article
- uses PDO to select from and insert into a database
- of PHP classes. XML representations of
- PHP classes, both internal and user-defined,
- are transformed into SQL INSERT statements using
- the SimpleXMLElement class.
- </para>
-
+ The project examined in this article uses PDO to select from and
+ insert into a database of PHP classes. XML representations of PHP
+ classes, both internal and user-defined, are transformed into SQL
+ INSERT statements using the SimpleXMLElement class.
+ </para>
+
<para>
- Even if your XML skills are
- weak, you'll find the SimpleXMLElement easy to
- understand and use. blah blah
+ Even if your XML skills are weak, you'll find the SimpleXMLElement
+ easy to understand and use. blah blah
</para>
</section>
@@ -401,21 +397,20 @@
<title>Creating a PDO Connection</title>
<para>
- Records are added to a database using a web form.
- Within this form a drop-down list box is
- populated with the names of classes that are not already included
- in the database, thereby eliminating duplicate submissions.
+ Records are added to a database using a web form. Within this form
+ a drop-down list box is populated with the names of classes that
+ are not already included in the database, thereby eliminating
+ duplicate submissions.
</para>
<para>
- The names of existing XML class files are copied from a
- directory into an array. This is
- done using a user-defined class,
- <literal>DirectoryItems</literal>, that copies the names of files in a
- specified directory (<filename>xml</filename> in this particular
- case) into an array. This array is
- compared to the classes already contained in the database to
- create a drop-down list of classes that aren't yet included.
+ The names of existing XML class files are copied from a directory
+ into an array. This is done using a user-defined class,
+ <literal>DirectoryItems</literal>, that copies the names of files
+ in a specified directory (<filename>xml</filename> in this
+ particular case) into an array. This array is compared to the
+ classes already contained in the database to create a drop-down
+ list of classes that aren't yet included.
</para>
<programlisting>
@@ -524,17 +519,17 @@
<title>Moving XML Data into a Database</title>
<para>
- The <literal>action</literal> attribute of the form in the
- the previous section is <filename>add_record.php</filename>.
- This is the file that inserts records into the tables.
+ The <literal>action</literal> attribute of the form in the the
+ previous section is <filename>add_record.php</filename>. This is
+ the file that inserts records into the tables.
</para>
-
+
<para>
Converting an XML document of a PHP class into a database format
is done using the XMLFormatToSQL class. This class creates a
SimpleXMLElement object and uses its methods to generate the SQL
- necessary to insert records into the
- <literal>phpclasses</literal> database.
+ necessary to insert records into the <literal>phpclasses</literal>
+ database.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7396 - in trunk: refman-4.1 refman-5.0 refman-5.1 userguide | plavin | 9 Aug |
