Author: plavin
Date: 2007-03-26 21:50:31 +0200 (Mon, 26 Mar 2007)
New Revision: 5566
Log:
Add basic admin file
Added:
trunk/userguide/basic-administration.xml
Added: trunk/userguide/basic-administration.xml
===================================================================
--- trunk/userguide/basic-administration.xml (rev 0)
+++ trunk/userguide/basic-administration.xml 2007-03-26 19:50:31 UTC (rev 5566)
Changed blocks: 1, Lines Added: 377, Lines Deleted: 0; 7531 bytes
@@ -0,0 +1,377 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
+<chapter id="installing">
+
+ <title>Basic Administration</title>
+
+ <section id="basic-administration">
+
+ <title>Introduction</title>
+
+ <para>
+ the way that you set rights for a development database and for a
+ production database will be quite different
+ </para>
+
+ <para>
+
+ Basic Admin tasks to get going reference post installation tasks
+ in ref man **** Privilege System Basics Securing Default User
+ Accounts Access Denied Errors
+ </para>
+
+ <para>
+ where are the databases
+ /var/lib/mysql
+ </para>
+
+ </section>
+
+<!-- END INTRODUCTION -->
+
+<!-- Start Initial start-up -->
+
+ <section>
+
+ <title>Initial Start-up</title>
+
+ <para>
+ stopping and starting mysqld
+ </para>
+
+ </section>
+
+<!-- End Initial start-up -->
+<!-- Start mysql client -->
+ <section id="mysql-client">
+
+ <title>The MySQL Client</title>
+
+ <para>
+
+ </para>
+
+ </section>
+<!-- End mysql client -->
+
+<!-- Start Utilities -->
+
+ <section>
+
+ <title>Other Administration Utilities</title>
+
+ <para></para>
+
+ <para>
+ using mysqld_safe mysqldump mysqlhotcopy
+ my_print_defaults
+ </para>
+
+ <itemizedlist>
+
+
+ <listitem>
+ <para>
+ mysqladmin
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <section id="mysqladmin">
+ <title>Using mysqladmin</title>
+
+ <para>
+ mysqladmin commands
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ shutdown
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ create
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ drop
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ ping
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ mysqladmin options
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ help host password user
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </para>
+
+ </section>
+
+ <section id="mysqldump">
+ <title>Using mysqldump</title>
+
+ <para>
+ a means of backing up your data
+ </para>
+
+ <para>
+ opt on by default -- what are these things
+ don't worry about now --- useful when file size is important
+ perhaps when restrictions in uploading to an online
+ </para>
+
+ <para>
+ --databases --all-databases
+ --fields-terminated -by
+ --force --host --password --user --port --opt xml
+ </para>
+
+ <para>
+ quick
+ This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than
+ retrieving the entire row set and buffering it in memory before writing it out.
+ </para>
+
+ </section>
+
+
+ </section>
+
+<!-- End Utilities -->
+
+<!--Start administering users-->
+
+ <section>
+
+ <title>Administering Users</title>
+
+ <para>
+ the way that you set rights for a development database and for a
+ production database will be quite different
+ </para>
+
+ </section>
+
+<!--End administering users-->
+
+
+
+<!--Start my.cnf-->
+
+ <section>
+
+ <title>The MySQL Configuration File</title>
+
+ <para>
+
+ </para>
+
+ <para>
+ sample files come with
+ make your life easier tee
+ </para>
+
+ <para>
+ on Windows the found in the
+ <filename>C:\Program Files\MySQL\MySQL Server 5.0\</filename> directory
+ on unix <filename>\usr\share\mysql</filename>
+ </para>
+
+ <table>
+ <title>Configuration files</title>
+ <tgroup cols="2">
+ <colspec colwidth="1in"/>
+ <colspec colwidth="1in"/>
+ <thead>
+ <row>
+ <entry><emphasis role="bold">Windows</emphasis></entry>
+ <entry><emphasis role="bold">Unix/Mac OS X</emphasis></entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>my-small.ini</entry>
+ <entry>my-small.cnf</entry>
+ </row>
+ <row>
+ <entry>my-medium.ini</entry>
+ <entry>my-medium.cnf</entry>
+ </row>
+ <row>
+ <entry>my-large.ini</entry>
+ <entry>my-large.cnf</entry>
+ </row>
+ <row>
+ <entry>my-huge.ini</entry>
+ <entry>my-huge.cnf</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
+
+ <para>
+ there are other files but these will do ()
+ </para>
+ <para>
+ the sections are:
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ client
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ mysqld
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ safe-mysqld
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ mysqldump
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ mysql
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+
+ </para>
+
+
+ <para>
+ You can copy this file to
+ # /etc/my.cnf to set global options,
+ # mysql-data-dir/my.cnf to set server-specific options (in this
+ # installation this directory is /var/lib/mysql) or
+ # ~/.my.cnf to set user-specific options.
+ </para>
+
+ <para>
+ must note the
+ different modes and why you would use a specific mode
+ </para>
+
+ <para>
+ set the default database type
+
+ </para>
+
+ <para>
+ a sample configuration file
+ </para>
+
+<programlisting>
+ #all clients
+ [client]
+ #don't use user -- let default
+ #user=peter
+ password=merlin
+
+ #apply to the shell only
+ [mysql]
+ #show current database as the prompt
+ prompt="\d > "
+ #allow use of LOAD DATA INFILE
+ local-infile=1
+
+ [mysqld]
+
+ sql-mode="TRADITIONAL"
+
+ #applies to mysqldump only
+ [mysqldump]
+ quick
+</programlisting>
+
+ <para>
+ explanation
+ </para>
+
+ </section>
+
+<!--End my.cnf-->
+ <!--Start MySQL Administrator-->
+
+ <section>
+
+ <title>Using MySQL Administrator</title>
+
+ <para>
+ Advantages
+ </para>
+
+ </section>
+
+ <!--End MySQL Administrator-->
+
+</chapter>
+<!-- END Basic Administration CHAPTER -->
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5566 - trunk/userguide | plavin | 26 Mar |
