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

[plavin]

Author: plavin
Date: 2007-03-24 21:11:21 +0100 (Sat, 24 Mar 2007)
New Revision: 5547

Log:
Corrections etc

Modified:
   trunk/userguide/excel-mysql.xml
   trunk/userguide/tools-tricks.xml


Modified: trunk/userguide/excel-mysql.xml
===================================================================
--- trunk/userguide/excel-mysql.xml	2007-03-24 07:40:31 UTC (rev 5546)
+++ trunk/userguide/excel-mysql.xml	2007-03-24 20:11:21 UTC (rev 5547)
Changed blocks: 3, Lines Added: 5, Lines Deleted: 2; 1195 bytes

@@ -879,7 +879,8 @@
       After altering database objects, it's always an idea to refresh the
       view in the <guilabel>Schemata</guilabel> pane. Do this by right
       clicking the <literal>spreadsheet</literal> database and choosing
-      the <guimenu>Refresh Schemata</guimenu> option.
+      the <guimenu>Refresh </guimenu> option (Under Unix this option is 
+      called <guimenu>Refresh Schemata</guimenu>.)
     </para>
 
     <para>

@@ -1248,7 +1249,7 @@
   ADD KEY `city_idx` (`city`); 
 
 ALTER TABLE `memberaccreditations` 
-ADD PRIMARY KEY (`certification`, `memberid`);  
+  ADD PRIMARY KEY (`certification`, `memberid`);  
 
 #create accreditations table
 DROP TABLE IF EXISTS accreditations; 

@@ -1256,6 +1257,8 @@
   SELECT DISTINCT certification AS acronym, '' AS description
   FROM alldata;
 
+ALTER TABLE `accreditations`
+  ADD PRIMARY KEY (`acronym`);
 #now add views
 DROP VIEW IF EXISTS vwOrphanedMembers;
   CREATE VIEW `vwOrphanedMembers` AS


Modified: trunk/userguide/tools-tricks.xml
===================================================================
--- trunk/userguide/tools-tricks.xml	2007-03-24 07:40:31 UTC (rev 5546)
+++ trunk/userguide/tools-tricks.xml	2007-03-24 20:11:21 UTC (rev 5547)
Changed blocks: 3, Lines Added: 73, Lines Deleted: 3; 2188 bytes

@@ -6,6 +6,11 @@
   <title>Tools and Tricks</title>
 
   <para>
+    a command-line client you can't just explore the interface to
+    find out about capabilities
+  </para>
+  
+  <para>
     various tools available for 
     You may already be familiar with mysqladmin
   </para>

@@ -53,13 +58,76 @@
   <section id="tools">
 
     <title>Command-Line Tools</title>
-
     
+    <para>
+      Moving data to and from 
+    </para>
     
     <para>
+      apart from <literal>mysql</literal> and
+      <literal>mysqlhotcopy</literal> since it doesn't
+      work on Windows.
+    </para>
+    
+    
+    <para>
+      <itemizedlist>
+        
+        <listitem>
+          <para>mysqldump</para>
+        </listitem>
+        
+        <listitem>
+          <para>mysqlimport</para>
+        </listitem>
+               
+        <listitem>
+          <para>mysqladmin</para>
+        </listitem>
+        
+      </itemizedlist>
       
     </para>
-
+    <section>
+      <title>mysqldump</title>
+      
+      <para>
+        
+      </para>
+    </section>
+    
+    <section>
+      <title></title>
+   
+    
+    <para>
+      data exported from another program
+      Invoke mysqlimport like this:
+      
+      shell> mysqlimport [options] db_name textfile1 [textfile2 ...]
+      
+      For each text file named on the command line, mysqlimport 
+      strips any extension from the filename and uses the result 
+      to determine the name of the table into which to import the 
+      file's contents. For example, files named 
+      patient.txt, patient.text, and patient all would be 
+      imported into a table named patient. 
+    </para>
+    
+    <para>
+      
+    </para>
+    </section>
+    
+    <section>
+      <title>mysqladmin</title>
+      
+      <para>
+        
+      </para>
+    </section>
+    
+    
   </section>
 
 <!-- End Command-Line Tools -->

@@ -68,7 +136,9 @@
     
     <title>GUI Tools</title>
     
-    <para></para>
+    <para>
+      
+    </para>
     
   </section>