svn commit - mysqldoc@docsrva: r5844 - trunk/userguide

[plavin]

Author: plavin
Date: 2007-04-12 01:09:21 +0200 (Thu, 12 Apr 2007)
New Revision: 5844

Log:
Minor corrections

Modified:
   trunk/userguide/mysqldump.xml


Modified: trunk/userguide/mysqldump.xml
===================================================================
--- trunk/userguide/mysqldump.xml	2007-04-11 22:55:56 UTC (rev 5843)
+++ trunk/userguide/mysqldump.xml	2007-04-11 23:09:21 UTC (rev 5844)
Changed blocks: 6, Lines Added: 15, Lines Deleted: 6; 3008 bytes

@@ -23,7 +23,7 @@
 
   <para>
     The <command>mysqldump</command> utility creates a script file of
-    SQL statements that recreate the database objects selected and it
+    SQL statements that recreate the database objects selected and it also
     creates <literal>INSERT</literal> statements to restore data. There
     are various other ways to back up MySQL databases or tables; using
     the <command>mysql</command> client program and SQL statements,

@@ -77,7 +77,7 @@
     <para>
       This section identifies the most commonly used options and briefly
       describes each one. Examples of using these options are given in
-      the following sections.
+      subsequent sections.
     </para>
 
     <para>

@@ -166,7 +166,7 @@
     <para>
       Use the <option>--tab</option> and
       <option>--fields-terminated-by</option> options, to dump a
-      database in a variety of text formats. For XML format use the
+      database in a variety of text formats. For XML format, use the
       <option>--xml</option> option. To select only specific rows from a
       table use the <option>--where</option> option.
     </para>

@@ -177,7 +177,7 @@
 
       <para>
         The <option>--opt</option> option is on by default so you don't
-        have to specify it. However, you need to know what it does.
+        have to specify it. However, you do need to know what it does.
         Using <option>--opt</option> is shorthand for specifying
         <option> --add-locks, --add-drop-table, --create-options,
         --disable-keys, --extended-insert, --lock-tables,

@@ -491,6 +491,15 @@
       database, but you will overwrite any tables in the existing
       database that have the same names as tables in the back-up file.
     </para>
+    
+    <para>
+      If you are uploading a database dump file to an online database then
+      you will have to specify the <option>--host</option> option. If you
don't
+      have access to your MySQL server from a remote location then copy your script file
+      to the server and use <literal>ssh</literal> to log in and then run 
+      <command>mysql</command>. Otherwise, you may be able to execute 
+      the script file using a program such as phpMyAdmin.
+    </para>
 
   </section>
 

@@ -626,8 +635,8 @@
 
     <para>
       Apart from exporting databases in various text formats, it is also
-      possible to export to other database formats such as <literal>MS
-      SQL Server</literal>, <literal>PostgreSQL</literal>, or even to
+      possible to export to other database formats such as MS
+      SQL Server, PostgreSQL, or even to
       convert to earlier versions of MySQL. This is done using the
      
<option>--compatible=<replaceable>name</replaceable></option>
       option. Using this option makes a best guess at transforming MySQL