New benchmark test

Fixed bug in REPLACE with BDB tables
Prepare for write lock on read for BDB
Inform the handler when we want to use IGNORE / REPLACE
New manual pages


Docs/manual.texi:
  Updates for BDB tables and new changes
client/mysql.cc:
  Cleanup
configure.in:
  Added sys/ioctl.h
heap/hp_rkey.c:
  Fixed bug when reading next on not unique key
include/my_base.h:
  Added new extra options
man/mysql.1:
  Added example
mysys/my_write.c:
  Safety fix
scripts/mysqlaccess.sh:
  Removed debug output
scripts/safe_mysqld.sh:
  Added --open-files-limit
sql-bench/Results/ATIS-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/RUN-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/alter-table-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/big-tables-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/connect-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/create-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/insert-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/select-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/Results/wisconsin-mysql-Linux_2.2.14_my_SMP_i686:
  Updated to new benchmark
sql-bench/bench-init.pl.sh:
  Updated to new benchmark
sql-bench/server-cfg.sh:
  Fixes for HEAP tables
sql-bench/test-ATIS.sh:
  Fix for heap tables
sql-bench/test-insert.sh:
  Added some ORDER BY benchmarks to test more things
sql/ha_berkeley.cc:
  Fix a bug in REPLACE
sql/ha_berkeley.h:
  Fix to handle lock_on_read
sql/mysql_priv.h:
  Prepare for internal subtransactions in BDB
sql/mysqld.cc:
  Added -O open_files_limit=#
sql/sql_insert.cc:
  Inform the handler when we want to use IGNORE / REPLACE
sql/sql_load.cc:
  Inform the handler when we want to use IGNORE / REPLACE
sql/sql_parse.cc:
  Cleanup
sql/sql_show.cc:
  Cleanup
sql/sql_table.cc:
  Inform the handler when we want to use IGNORE / REPLACE
sql/sql_update.cc:
  Inform the handler when we want to use IGNORE / REPLACE
support-files/binary-configure.sh:
  Better message

14 files changed, 1565 insertions, 0 deletions

diff --git a/man/isamchk.1 b/man/isamchk.1
new file mode 100755
index 00000000000..f225dc35d18
--- /dev/null
+++ b/man/isamchk.1
@@ -0,0 +1,140 @@
+.TH ISAMCHK 1 "19 December 2000"
+.SH NAME
+.BR isamchk
+ \- Description, check and repair of ISAM tables.
+Used without options all tables on the command will be checked for errors
+.SH USAGE
+isamchk [OPTIONS] tables[.ISM]
+.SH SYNOPSIS
+.B isamchk
+.RB [  \-a | \-\-analyze ]
+.RB [  \-# | \-\-debug=...  ]
+.RB [  \-\-character\-sets\-dir=...]
+.RB [  \-C | \-\-default\-character\-set=...]
+.RB [  \-d | \-\-description  ]
+.RB [  \-e | \-\-extend\-check  ]
+.RB [  \-f | \-\-force  ]      
+.RB [  \-? | \-\-help       ]   
+.RB [  \-i | \-\-information  ]
+.RB [  \-k | \-\-keys\-used=#   ]
+.RB [  \-l | \-\-no\-symlinks]   
+.RB [  \-q | \-\-quick      ]  
+.RB [  \-r | \-\-recover       ]
+.RB [  \-o | \-\-safe\-recover  ]
+.RB [  \-O | "\-\-set\-variable var=option"]
+.RB [  \-s | \-\-silent ]      
+.RB [  \-S | \-\-sort\-index    ]
+.RB [  \-R | \-\-sort\-records=#]
+.RB [  \-u | \-\-unpack       ]
+.RB [  \-v | \-\-verbose  ]    
+.RB [  \-V | \-\-version ]    
+.RB [  \-w | \-\-wait ]         
+.SH DESCRIPTION
+.TP
+.BR  \-a | \-\-analyze
+Analyze distribution of keys. Will make some joins in
+MySQL faster.
+.TP 
+.BR  \-# | \-\-debug=...
+Output debug log. Often this is 'd:t:o ,filename`
+.TP 
+.BR \-\-character\-sets\-dir=...
+Directory where character sets are
+.TP 
+.BR  \-C | \-\-default\-character\-set=...
+Set the default character set
+.TP 
+.BR    \-d | \-\-description
+Prints some information about table.
+.TP 
+.BR    \-e | \-\-extend\-check
+Check the table VERY thoroughly.  One need use this
+only in extreme cases as isamchk should normally find
+all errors even without this switch
+.TP 
+.BR    \-f | \-\-force
+Overwrite old temporary files.
+If one uses \-f when checking tables (running isamchk
+without \-r), isamchk will automatically restart with
+\-r on any wrong table.
+.TP 
+.BR    \-? | \-\-help
+Display help and exit.
+.TP 
+.BR    \-i | \-\-information
+Print statistics information about the table
+.TP 
+.BR    \-k | \-\-keys\-used=#   
+Used with '\-r'. Tell ISAM to update only the first
+# keys.  This can be used to get faster inserts!
+.TP 
+.BR    \-l | \-\-no\-symlinks   
+Do not follow symbolic links when repairing. Normally
+isamchk repairs the table a symlink points at.
+.TP 
+.BR    \-q | \-\-quick
+Used with \-r to get a faster repair. (The data file
+isn't touched.) One can give a second '\-q' to force
+isamchk to modify the original datafile.
+.TP 
+.BR    \-r | \-\-recover
+Can fix almost anything except unique keys that aren't
+unique.
+.TP 
+.BR    \-o | \-\-safe\-recover  
+Uses old recovery method; slower than '\-r' but can
+handle a couple of cases that '\-r' cannot handle.
+.TP 
+.BR    \-O | " \-\-set\-variable var=option "
+Change the value of a variable.
+.TP 
+.BR    \-s | \-\-silent
+Only print errors.  One can use two \-s to make isamchk
+very silent
+.TP 
+.BR    \-S | \-\-sort\-index
+Sort index blocks.  This speeds up 'read\-next' in
+applications
+.TP 
+.BR    \-R | \-\-sort\-records=#
+Sort records according to an index.  This makes your
+data much more localized and may speed up things
+(It may be VERY slow to do a sort the first time!)
+.TP 
+.BR    \-u | \-\-unpack
+Unpack file packed with pack_isam.
+.TP 
+.BR    \-v | \-\-verbose
+Print more information. This can be used with
+\-d and \-e. Use many \-v for more verbosity!
+.TP 
+.BR    \-V | \-\-version
+Print version and exit.
+.TP 
+.BR    \-w | \-\-wait
+Wait if table is locked.
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill\-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+.\" end of man page
diff --git a/man/isamlog.1 b/man/isamlog.1
new file mode 100644
index 00000000000..efc042ccd7c
--- /dev/null
+++ b/man/isamlog.1
@@ -0,0 +1,103 @@
+.TH ISAMLOG 1 "20 December 2000" 
+.SH NAME 
+isamlog - Write info about whats in a nisam log file. 
+.SH USAGE 
+isamlog [-?iruvIV] [-c #] [-f #] [-F filepath/] [-o #] [-R file recordpos] [-w write_file] [log-filename [table ...]] 
+.SH SYNOPSIS 
+.B isamlog 
+.RB [ -?  |  -I ] 
+.RB [ -V ] 
+.RB [ -c ] 
+.RB [ -f ] 
+.RB [ -F ] 
+.RB [ -i ] 
+.RB [ -o ] 
+.RB [ "-p #" ] 
+.RB [ -r ] 
+.RB [ -R ] 
+.RB [ -u ] 
+.RB [ -v ] 
+.RB [ -w ] 
+.SH DESCRIPTION 
+.TP
+.BR isamlog
+.TP
+.BR -?  |  -I
+info
+.TP
+.BR -V
+version
+.TP
+.BR -c
+do only # commands
+.TP
+.BR -f
+max open files
+.TP
+.BR -F
+file path
+.TP
+.BR -i
+extra info
+.TP
+.BR -o
+offset
+.TP
+.BR "-p #"
+remove # components from path
+.TP
+.BR -r
+recover
+.TP
+.BR -R
+file recordposition
+.TP
+.BR -u
+update
+.TP
+.BR -v
+verbose
+.TP
+.BR -w
+write file
+.SH NOTE 
+If no file name is given isam.log is used
+One can give a second and a third '-v' for more verbose.
+Normaly one does a update (-u).
+If a recover is done all writes and all possibly updates and deletes is done
+and errors are only counted.
+If one gives table names as arguments only these tables will be updated
+
+
+
+.SH "SEE ALSO" 
+
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+
+.SH AUTHOR 
+
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+
+.\" end of man page
+
+
diff --git a/man/mysql.1 b/man/mysql.1
index e0b77363a82..96ccca8f50e 100644
--- a/man/mysql.1
+++ b/man/mysql.1
@@ -116,6 +116,13 @@ executable shell script for starting mysqld safely
 .TP
 .I /site/var/mysql/data
 location of database files
+.SH EXAMPLE
+You can also read a backup dump file back into MySQL with: 
+.TP
+.BR mysql 
+\fP\fIdatabase\fP 
+.BR < 
+backup-file.sql
 .SH "SEE ALSO"
 isamchk (1),
 isamlog (1),
diff --git a/man/mysql_zap.1 b/man/mysql_zap.1
new file mode 100644
index 00000000000..98da195894e
--- /dev/null
+++ b/man/mysql_zap.1
@@ -0,0 +1,34 @@
+.TH ZAP 1 "20 December 2000" 
+.SH NAME 
+zap - a perl script used to kill processes 
+.SH USAGE 
+/usr/bin/mysql_zap [-signal] [-?Ift] pattern
+.SH SYNOPSIS 
+.B zap 
+.RB [ \-I | \-? ] 
+.RB [ \-f ] 
+.RB [ \-t ] 
+.SH DESCRIPTION 
+.TP
+.BR zap
+supports by executing
+.TP
+.BR \-I | \-?
+info
+.TP
+.BR \-f
+force
+.TP
+.BR \-t
+test
+.SH NOTE 
+If 
+.BR -f 
+isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with signal 9. If 
+.BR -t 
+is given the processes is only shown on stdout.
+.SH "SEE ALSO" 
+isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1), replace (1), safe_mysqld (1), which1 (1), zap (1),
+.SH AUTHOR 
+Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurmedia.com) 
+.\" end of man page 
\ No newline at end of file
diff --git a/man/mysqlaccess.1 b/man/mysqlaccess.1
new file mode 100755
index 00000000000..888cfe8f646
--- /dev/null
+++ b/man/mysqlaccess.1
@@ -0,0 +1,121 @@
+.TH MYSQLACCESS 1 "19 December 2000"
+.SH NAME
+.BR mysqlaccess
+ \- Create new users to mysql.
+.SH USAGE
+mysqlaccess [host [user [db]]] OPTIONS
+.SH SYNOPSIS
+.B mysqlaccess
+.RB [  \-? | \-\-help ]
+.RB [  \-v | \-\-version ]
+.RB [  \-p | \-\-password=#  ]
+.RB [  \-h | \-\-host=# ]
+.RB [  \-d | \-\-db=# ]
+.RB [  \-U | \-\-superuser=# ]
+.RB [  \-P | \-\-spassword=# ]
+.RB [  \-H | \-\-rhost=#  ]
+.RB [  \-\-old_server ]
+.RB [ \-b | \-\-brief  ]
+.RB [  \-t | \-\-table  ]
+.RB [  \-\-relnotes]
+.RB [  \-\-plan ]
+.RB [  \-\-howto   ]
+.RB [  \-\-debug=N ]
+.RB [  \-\-copy  ]
+.RB [  \-\-preview   ]
+.RB [  \-\-commit  ]
+.RB [  \-\-rollback  ]
+.SH DESCRIPTION
+.TP 
+.BR  \-? | \-\-help
+display this helpscreen and exit
+.TP 
+.BR   \-v | \-\-version 
+print information on the program `mysqlaccess'
+.TP 
+.BR  \-u | \-\-user=# 
+username for logging in to the db
+.TP 
+.BR \-p | \-\-password=#
+validate password for user
+.TP 
+.BR   \-h | \-\-host=# 
+name or IP\-number of the host
+.TP 
+.BR   \-d | \-\-db=#
+name of the database
+.TP 
+.BR \-U | \-\-superuser=#
+connect as superuser
+.TP 
+.BR   \-P | \-\-spassword=# 
+password for superuser
+.TP 
+.BR   \-H | \-\-rhost=# 
+remote MySQL\-server to connect to
+.TP 
+.BR \-\-old_server
+connect to old MySQL\-server (before v3.21) which 
+does not yet know how to handle full where clauses.
+.TP 
+.BR  \-b | \-\-brief
+single\-line tabular report
+.TP 
+.BR   \-t | \-\-table
+report in table\-format
+.TP 
+.BR   \-\-relnotes
+print release\-notes
+.TP 
+.BR   \-\-plan
+print suggestions/ideas for future releases
+.TP 
+.BR   \-\-howto
+some examples of how to run `mysqlaccess'
+.TP 
+.BR   \-\-debug=N
+enter debuglevel N (0..3)
+.TP 
+.BR   \-\-copy 
+reload temporary grant\-tables from original ones
+.TP 
+.BR   \-\-preview 
+show differences in privileges after making
+changes in (temporary) grant\-tables
+.TP 
+.BR   \-\-commit
+copy grant\-rules from temporary tables to grant\-tables
+(!don't forget to do an mysqladmin reload)
+.TP 
+.BR   \-\-rollback
+undo the last changes to the grant\-tables.
+.SH NOTE
+    + At least the user and the db must be given (even with wildcards)
+    + If no host is given, `localhost' is assumed
+    + Wilcards (*,?,%,_) are allowed for host, user and db, but be sure 
+      to escape them from your shell!! (ie type \* or '*')
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill\-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+.\" end of man page
diff --git a/man/mysqladmin.1 b/man/mysqladmin.1
new file mode 100755
index 00000000000..58bd2070de6
--- /dev/null
+++ b/man/mysqladmin.1
@@ -0,0 +1,208 @@
+.TH MYSQLADMIN 1 "18 December 2000"
+.SH NAME
+ mysqladmin [OPTIONS] command command....  \- A utility for performing administrative operations
+.SH OPTION SYNOPSIS
+.B mysqladmin
+.RB [ \-# | \-\-debug=
+.IR logfile ]
+.RB [ \-f | \-\-force ]
+.RB [ \-? | \-\-help ]
+.BR [ --character-sets-dir=\fP\fIdirectory\fP ]
+.RB [ \-C | \-\-compress ]
+.RB [ \-h | \-\-host=[#] ]
+.RB [ \-p[pwd] ]
+.RI [ \-\-password=[pwd] ]
+.RB [ \-P | \-\-port=
+.IR pnum ]
+.RB [ \-i | \-\-sleep=
+.IR sec ]
+.RB [ \-E | \-\-vertical ]
+.RB [ \-s | \-\-silent ]
+.RB [ \-S | \-\-socket=
+.IR # ]
+.RB [ \-r | \-\-relative ]
+.RB [ \-t | \-\-timeout=
+.IR # ]
+.RB [ \-u | \-\-user=
+.IR uname ]
+.RB [ \-v | \-\-verbose ]
+.RB [ \-V | \-\-version ]
+.RB [ \-w | \-\-wait[=retries] ]
+.SH OPTION DESCRIPTION
+You can get a list of the options your version of 
+.IR mysqladmin 
+supports by executing 
+.BR "mysqladmin \-\-help" 
+.SH OPTIONS
+.TP
+.BR \-# | \-\-debug=\fP\fIlogfile\fP
+Output debug log. Often this is 'd:t:o,filename`
+.TP
+.BR \-f | \-\-force 
+Don't ask for confirmation on drop database; with
+multiple commands, continue even if an error occurs
+.TP
+.BR  \-? | \-\-help
+ Display help and exit
+.TP
+.BR  --character-sets-dir=\fP\fIdirectory\fP
+Set the character set directory
+.TP
+.BR  \-C | \-\-compress
+Use compression in server/client protocol
+.TP
+\fB\-h\fP|\fP\-\-host=\fP\fIhostname\fP
+Connect to host
+.TP
+\fB\-p\fP|\fB\-\-password\fP[\fB=\fP\fIpwd\fP]
+Password to use when connecting to server
+If password is not given it's asked from the tty
+.TP
+\fB\-P\fR|\fB\-\-port=\fP\fIpnum\fP
+Port number to use for connection
+.TP  
+\fB\-i\fR|\fB\-\-sleep=\fP\fIsec\fP
+Execute commands again and again with a sleep between
+.TP
+.BR \-r | \-\-relative
+Show difference between current and previous values
+when used with 
+.BR -i
+. Currently works only with
+extended-status
+.TP
+.BR  \-E | \-\-vertical
+Print output vertically. Is similar to 
+.BR --relative,
+but prints output vertically.
+.TP
+.BR  \-s | \-\-silent
+Silently exit if one can't connect to server
+.TP
+\fB\-S\fR|\fB\-\-socket=\fP\fIfile\fP
+Socket file to use for connection
+.TP
+\fB\-t\fR|\fB\-\-timeout=\fP\fIsec\fP
+Timeout for connection to the mysqld server
+.TP
+\fB\-u\fP|\fB\-\-user=\fP\fIuname\fP
+User for login if not current user
+.TP
+.BR \-v | \-\-verbose
+Write more information
+.TP
+.BR \-V | \-\-version
+Output version information and exit
+.TP
+.BR \-w | \-\-wait
+  Wait and retry if connection is down
+.SH COMMAND SYNOPSIS  
+.B MySQLADMIN
+.RB [ "create \fP\fIdatabasename\fP "]
+.RB [ "drop \fP\fIdatabasename\fP" ]
+.RB [ extended-status ]
+.RB [ flush-hosts ]
+.RB [ flush-logs ]
+.RB [ flush-tables ]
+.RB [ flush-privileges ]
+.RB [ " kill id,id,... "  ]
+.RB [ "password \fP\fInew-password\fP "]
+.RB [ ping ]
+.RB [ processlist  ]
+.RB [ reload ]
+.RB [ refresh ]
+.RB [ shutdown ]
+.RB [ slave-start ]
+.RB [ slave-stop ]
+.RB [ status ]
+.RB [ variables ]
+.RB [ version  ]
+
+.SH COMMANDS
+Where command is a one or more of: (Commands may be shortened)
+.TP
+.BR "create databasename"
+Create a new database
+.TP
+.BR "drop databasename"
+Delete a database and all its tables
+.TP
+.BR  extended-status
+Gives an extended status message from the server
+.TP
+.BR  flush-hosts 
+Flush all cached hosts
+.TP
+.BR flush-logs
+Flush all logs
+.TP
+.BR  flush-status
+Clear status variables
+.TP
+.BR  flush-tables
+Flush all tables
+.TP
+.BR  flush-threads
+Flush the thread cache
+.TP
+.BR  flush-privileges
+Reload grant tables (same as reload)
+.TP
+.BR  "kill id,id,..."
+Kill mysql threads
+.TP
+.BR  "password \fP\fInew-password\fP" 
+Change old password to new-password
+.TP
+.BR  ping
+Check if mysqld is alive
+.TP
+.BR  processlist
+Show list of active threads in server
+.TP
+.BR  reload
+Reload grant tables
+.TP
+.BR  refresh
+Flush all tables and close and open logfiles
+.TP
+.BR  shutdown 
+Take server down
+.TP
+.BR  status
+Gives a short status message from the server
+.TP
+.BR  variables
+Prints variables available
+.TP
+.BR  version
+Get version info from server  
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+.\" end of man page
+
+
+
+
+
diff --git a/man/mysqld.1 b/man/mysqld.1
new file mode 100755
index 00000000000..d3f22c0be1b
--- /dev/null
+++ b/man/mysqld.1
@@ -0,0 +1,230 @@
+.TH MYSQLD 1 "19 December 2000"
+.SH NAME
+.BR mysqld
+ \- Starts the MySQL server demon
+.SH USAGE
+mysqld [OPTIONS]
+.SH SYNOPSIS
+.B mysqld
+.RB [ \-\-ansi ]
+.RB [ \-b | \-\-basedir=\fP\fIpath\fP ]
+.RB [ \-\-big-tables ]
+.RB [ \-\-bind\-address=IP ]
+.RB [ \-\-character\-sets\-dir=\fP\fIpath\fP ]
+.RB [ \-\-chroot=\fP\fIpath\fP ]
+.RB [ \-h | \-\-datadir=\fP\fIpath\fP ]
+.RB [ \-\-default\-character\-set=\fP\fIcharset\fP ]
+.RB [ \-\-default\-table\-type=\fP\fItype \fP]
+.RB [ \-\-delay\-key\-write\-for\-all\-tables ]
+.RB [ \-\-enable\-locking ]
+.RB [ \-T | \-\-exit\-info] 
+.RB [ \-\-flush ]
+.RB [ \-? | \-\-help ]
+.RB [ \-\-init\-file=file ]
+.RB [ \-L | \-\-language=... ]
+.RB [ \-l | \-\-log[=file] ]
+.RB [ \-\-log\-isam[=file] ]
+.RB [ \-\-log\-slow\-queries\fP\fI[=file]\fP ]
+.RB [ \-\-log\-update\fP\fI[=file]\fP ]
+.RB [ \-\-log\-long\-format ]
+.RB [ \-\-low\-priority\-updates ]
+.RB [ \-\-memlock ]
+.RB [ " \-\-myisam\-recover [=option[,option...]]] where option is one of DEFAULT, BACKUP, FORCE or QUICK." ]
+.RB [ \-\-pid\-file=\fP\fIpath\fP ]
+.RB [ \-P | \-\-port=... ]
+.RB [ \-o | \-\-old\-protocol ]
+.RB [ \-\-one\-thread ]
+.RB [ \-O | \-\-set\-variable var=\fP\fIoption\fP ]
+.RB [ \-Sg | \-\-skip\-grant\-tables ]
+.RB [ \-\-safe\-mode ]
+.RB [ \-\-secure ]
+.RB [ \-\-skip\-concurrent\-insert ]
+.RB [ \-\-skip\-delay\-key\-write ]
+.RB [ \-\-skip\-locking ]
+.RB [ \-\-skip\-name\-resolve ]
+.RB [ \-\-skip\-networking ]
+.RB [ \-\-skip\-new ]
+.RB [ \-\-skip\-host\-cache ]
+.RB [ \-\-skip\-show\-database ]
+.RB [ \-\-skip\-thread\-priority ]
+.RB [ \-\-socket=path ]
+.RB [ \-t | \-\-tmpdir=\fP\fIpath \fP]
+.RB [ \-u | \-\-user=\fP\fIuser_name\fP ]
+.RB [ \-V | \-\-version ]
+.SH DESCRIPTION
+.TP 
+.BR --ansi 
+Use ANSI SQL syntax instead of MySQL syntax. See section 5.2 Running MySQL in ANSI Mode. 
+.TP 
+.BR -b | --basedir=\fP\fIpath \fP
+Path to installation directory. All paths are usually resolved relative to this. 
+.TP 
+.BR --big-tables 
+Allow big result sets by saving all temporary sets on file. It solves most 'table full' errors, but also slows down the queries where in\-memory tables would suffice. Since Version 3.23.2, MySQL is able to solve it automaticaly by using memory for small temporary tables and switching to disk tables where necessary. 
+.TP 
+.BR \-\-bind\-address=\fP\fIIP \fP
+IP address to bind to. 
+.TP 
+.BR \-\-character\-sets\-dir=\fP\fIpath \fP
+Directory where character sets are. See section 10.1.1 The Character Set Used for Data and Sorting. 
+.TP 
+.BR \-\-chroot=\fP\fIpath \fP
+Chroot mysqld daemon during startup. Recommended security measure. It will somewhat limit LOAD DATA INFILE and SELECT ... INTO OUTFILE though. 
+.TP 
+.BR \-h | \-\-datadir=\fP\fIpath \fP
+Path to the database root. 
+.TP 
+.BR \-\-default\-character\-set=\fP\fIcharset \fP
+Set the default character set. See section 10.1.1 The Character Set Used for Data and Sorting. 
+.TP 
+.BR \-\-default\-table\-type=\fP\fItype \fP
+Set the default table type for tables. See section 8 MySQL Table Types. 
+.TP 
+.BR \-\-delay\-key\-write\-for\-all\-tables 
+Don't flush key buffers between writes for any MyISAM table. See Mysql Manual section 12.2.3 Tuning Server Parameters. 
+.TP 
+.BR \-\-enable\-locking 
+Enable system locking. 
+.TP 
+.BR \-T | \-\-exit\-info 
+Print some debug info at exit. 
+.TP 
+.BR \-\-flush 
+Flush all changes to disk after each SQL command. Normally MySQL only does a write of all changes to disk after each SQL command and lets the operating system handle the syncing to disk. See section 20.2 What to Do if MySQL Keeps Crashing. 
+.TP 
+.BR \-? | \-\-help 
+Display short help and exit. 
+.TP 
+.BR \-\-init\-file=\fP\fIfile \fP
+Read SQL commands from this file at startup. 
+.TP 
+.BR \-L | \-\-language=... 
+Client error messages in given language. May be given as a full path. See Mysql Manual section 10.1 What Languages Are Supported by MySQL?. 
+.TP 
+.BR \-l | \-\-log\fP\fI[=file] \fP
+Log connections and queries to file. 
+.TP 
+.BR \-\-log\-isam\fP\fI[=file] \fP
+Log all ISAM/MyISAM changes to file (only used when debugging ISAM/MyISAM). 
+.TP 
+.BR \-\-log\-slow\-queries\fP\fI[=file] \fP
+Log all queries that have taken more than long_query_time seconds to execute to file. See Mysql Manual section 21.5 The Slow Query Log. 
+.TP 
+.BR \-\-log\-update\fP\fI[=file] \fP
+Log updates to file.# where # is a unique number if not given. See Mysql Manual section 21.3 The Update Log. 
+.TP 
+.BR \-\-log\-long\-format 
+Log some extra information to update log. If you are using 
+.BR \-\-log\-slow\-queries 
+then queries that are not using indexes are logged to the slow query log. 
+.TP 
+.BR \-\-low\-priority\-updates 
+Table\-modifying operations (INSERT/DELETE/UPDATE) will have lower priority than selects. It can also be done via {INSERT | REPLACE | UPDATE | DELETE} LOW_PRIORITY ... to lower the priority of only one query, or by SET OPTION SQL_LOW_PRIORITY_UPDATES=1 to change the priority in one thread. See Mysql Manual section  12.2.9 Table Locking Issues. 
+.TP 
+.BR \-\-memlock 
+Lock the mysqld process in memory. This works only if your system supports the mlockall() system call. This may help if you have a problem where the operating system is causing mysqld to swap on disk. 
+.TP 
+.BR " \-\-myisam\-recover [=option[,option...]]] where option is one of DEFAULT, BACKUP, FORCE or QUICK. " 
+If this option is used, mysqld will on open check if the table is marked as crashed or if if the table wasn't closed properly (The last option only works if you are running with \-\-skip\-locking). If this is the case mysqld will run check on the table. If the table was corrupted, mysqld will attempt to repair it. The following options affects how the repair works. 
+.BR DEFAULT
+The same as not giving any option to \-\-myisam\-recover.  
+.BR BACKUP 
+If the data table was changed during recover, save a backup of the `table_name.MYD' data file as `table_name\-datetime.BAK'.  
+.BR FORCE 
+Run recover even if we will loose more than one row from the .MYD file.  
+.BR QUICK  
+Don't check the rows in the table if there isn't any delete blocks.  
+Before a table is automaticly repaired, mysqld will add a note about this in the error log. If you want to be able to recover from most things without user intervention, you should use the options BACKUP,FORCE. This will force a repair of a table even if some rows would be deleted, but it will keep the old data file as a backup so that you can later examine what happened. 
+.TP 
+.BR \-\-pid\-file=\fP\fIpath \fP
+Path to pid file used by safe_mysqld. 
+.TP 
+.BR \-P | \-\-port=... 
+Port number to listen for TCP/IP connections. 
+.TP 
+.BR \-o | \-\-old\-protocol 
+Use the 3.20 protocol for compatibility with some very old clients. See Mysql Manual section  4.17.3 Upgrading from Version 3.20 to Version 3.21. 
+.TP 
+.BR \-\-one\-thread 
+Only use one thread (for debugging under Linux). See Mysql Manual section  H.1 Debugging a MySQL server. 
+.TP 
+.BR \-O | " \-\-set\-variable var=\fP\fIoption\fP "
+Give a variable a value. \-\-help lists variables. You can find a full description for all variables in the SHOW VARIABLES section in this manual. See Mysql Manual section  7.28.4 SHOW VARIABLES. The tuning server parameters section includes information of how to optimize these. See Mysql Manual section  12.2.3 Tuning Server Parameters. 
+.TP 
+.BR \-Sg | \-\-skip\-grant\-tables 
+This option causes the server not to use the privilege system at all. This gives everyone full access to all databases! (You can tell a running server to start using the grant tables again by executing mysqladmin flush\-privileges or mysqladmin reload.) 
+.TP 
+.BR \-\-safe\-mode 
+Skip some optimize stages. Implies 
+.BR \-\-skip\-delay\-key\-write. 
+.TP 
+.BR \-\-secure 
+IP numbers returned by the gethostbyname() system call are checked to make sure they resolve back to the original hostname. This makes it harder for someone on the outside to get access by pretending to be another host. This option also adds some sanity checks of hostnames. The option is turned off by default in MySQL Version 3.21 because sometimes it takes a long time to perform backward resolutions. MySQL Version 3.22 caches hostnames (unless \-\-skip\-host\-cache is used) and has this option enabled by default. 
+.TP 
+.BR \-\-skip\-concurrent\-insert 
+Turn off the ability to select and insert at the same time on MyISAM tables. (This is only to be used if you think you have found a bug in this feature). 
+.TP 
+.BR \-\-skip\-delay\-key\-write 
+Ignore the delay_key_write option for all tables. See Mysql Manual section  12.2.3 Tuning Server Parameters. 
+.TP 
+.BR \-\-skip\-locking 
+Don't use system locking. To use isamchk or myisamchk you must shut down the server. See Mysql Manual section  1.6 How Stable Is MySQL?. Note that in MySQL Version 3.23 you can use REPAIR and CHECK to repair/check MyISAM tables. 
+.TP 
+.BR \-\-skip\-name\-resolve 
+Hostnames are not resolved. All Host column values in the grant tables must be IP numbers or localhost. 
+.TP 
+.BR \-\-skip\-networking 
+Don't listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sockets. This option is highly recommended for systems where only local requests are allowed. However, this option is unsuitable for systems that use MIT\-pthreads, because the MIT\-pthreads package doesn't support Unix sockets. 
+.TP 
+.BR \-\-skip\-new 
+Don't use new, possible wrong routines. Implies 
+.BR \-\-skip\-delay\-key\-write
+. This will also set default table type to ISAM. See Mysql Manual section  8.3 ISAM Tables. 
+.TP 
+.BR \-\-skip\-host\-cache 
+Never use host name cache for faster name\-ip resolution, but query DNS server on every connect instead. 
+.TP 
+.BR \-\-skip\-show\-database 
+Don't allow 'SHOW DATABASE' commands, unless the user has process privilege. 
+.TP 
+.BR \-\-skip\-thread\-priority 
+Disable using thread priorities for faster response time. 
+.TP 
+.BR \-\-socket=\fP\fIpath \fP
+Socket file to use for local connections instead of default /tmp/mysql.sock. 
+.TP 
+.BR \-t | \-\-tmpdir=\fP\fIpath\fP 
+Path for temporary files. It may be useful if your default /tmp directory resides on a partition too small to hold temporary tables. 
+.TP 
+.BR \-u | \-\-user=\fP\fIuser_name \fP
+Run mysqld daemon as user user_name. This option is mandatory when starting mysqld as root. 
+.TP 
+.BR \-V | \-\-version 
+Output version information and exit. 
+
+.SH NOTE
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill\-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+.\" end of man page
diff --git a/man/mysqld_multi.1 b/man/mysqld_multi.1
new file mode 100644
index 00000000000..b68050e92ef
--- /dev/null
+++ b/man/mysqld_multi.1
@@ -0,0 +1,90 @@
+.TH MYSQLD_MULTI  1 "20 December 2000" 
+.SH NAME 
+mysqld_multi  - is meant for managing several mysqld processes running in different UNIX sockets and TCP/IP ports. 
+.SH USAGE 
+mysqld_multi [OPTIONS] {start|stop|report} [GNR,GNR,GNR...]
+.SH SYNOPSIS 
+.B mysqld_multi  
+.RB [ --config-file=... ] 
+.RB [ --example  ] 
+.RB [ --help  ] 
+.RB [ --log=...  ] 
+.RB [ --mysqladmin=...  ] 
+.RB [ --mysqld=...  ] 
+.RB [ --no-log  ] 
+.RB [ --password=... ] 
+.RB [ --tcp-ip  ] 
+.RB [ --user=...  ] 
+.RB [ --version  ] 
+.SH DESCRIPTION 
+.TP
+.BR mysqld_multi 
+.TP
+.BR --config-file=...
+Alternative config file. NOTE: This will not affect this program\'s own options (group [mysqld_multi]), but only groups [mysqld#]. Without this option everything will be searched from the ordinary my.cnf file. 
+.TP
+.BR --example 
+Give an example of a config file. 
+.TP
+.BR --help 
+Print this help and exit. 
+.TP
+.BR --log=... 
+Log file. Full path to and the name for the log file. NOTE: If the file exists, everything will be appended. 
+.TP
+.BR --mysqladmin=... 
+mysqladmin binary to be used for a server shutdown. 
+.TP
+.BR --mysqld=... 
+mysqld binary to be used. Note that you can give safe_mysqld to this option also. The options are passed to mysqld. Just make sure you have mysqld in your environment variable PATH or fix safe_mysqld. 
+.TP
+.BR --no-log 
+Print to stdout instead of the log file. By default the log file is turned on. 
+.TP
+.BR --password=...
+Password for user for mysqladmin. 
+.TP
+.BR --tcp-ip 
+Connect to the MySQL server(s) via the TCP/IP port instead of the UNIX socket. This affects stopping and reporting. If a socket file is missing, the server may still be running, but can be accessed only via the TCP/IP port. By default connecting is done via the UNIX socket. 
+.TP
+.BR --user=... 
+MySQL user for mysqladmin. 
+.TP
+.BR --version 
+Print the version number and exit. 
+.SH NOTE 
+Please see the mysql manual for more detailed information on this.
+
+
+
+.SH "SEE ALSO" 
+
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+
+.SH AUTHOR 
+
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+
+.\" end of man page
+
+
diff --git a/man/mysqldump.1 b/man/mysqldump.1
new file mode 100755
index 00000000000..f108da17bf9
--- /dev/null
+++ b/man/mysqldump.1
@@ -0,0 +1,273 @@
+.TH MYSQLDUMP 1 "19 December 2000"
+.SH NAME
+mysqldump \- text-based client for dumping or backing up mysql databases , tables and or data.
+
+.SH  USAGE
+.BR "mysqldump [\fP\fIOPTIONS\fP] database [\fP\fItables\fP]"
+.TP
+OR
+.BR "mysqldump [\fP\fIOPTIONS\fP] \-\-databases [\fP\fIOPTIONS\fP] DB1 [\fP\fIDB2 DB3...\fP]"
+.TP
+OR
+.BR "mysqldump [\fP\fIOPTIONS\fP] \-\-all-databases [\fP\fIOPTIONS\fP]"
+
+.SH OPTION SYNOPSIS
+.B mysqldump
+.RB [  \-A | \-\-all-databases ]
+.RB [  \-a | \-\-all ]
+.RB [  \-# | \-\-debug=... ]
+.RB [  \-\-character-sets-dir=...]
+.RB [ \-? | \-\-help       ]
+.RB [  \-B | \-\-databases     ]
+.RB [  \-c | \-\-complete-insert ]
+.RB [  \-C | \-\-compress       ]
+.RB [  \-\-default-character-set=...]
+.RB [ \-e | \-\-extended-insert ]
+.RB [  \-\-add-drop-table      ]
+.RB [  \-\-add-locks          ] 
+.RB [  \-\-allow-keywords      ]
+.RB [  \-\-delayed-insert      ]
+.RB [  \-F | \-\-flush-logs    ]
+.RB [  \-f | \-\-force     ]     
+.RB [  \-h | \-\-host=...       ]
+.RB [  \-l | \-\-lock-tables    ]
+.RB [  \-n | \-\-no-create-db ]   
+.RB [  \-t | \-\-no-create-info  ]
+.RB [  \-d | \-\-no-data     ]    
+.RB [  \-O | \-\-set-variable var=\fP\fIoption\fP         ]               
+.RB [  \-\-opt       ]         
+.RB [  \-p | \-\-password\fP\fI[=...]\fP  ]
+.RB [  \-P | \-\-port=...       ]
+.RB [  \-q | \-\-quick      ]    
+.RB [  \-Q | \-\-quote-names ]   
+.RB [  \-S | \-\-socket=...  ] 
+.RB [  \-\-tables   ]       
+.RB [  \-T | \-\-tab=...  ]      
+.RB [  \-u | \-\-user=# ]
+.RB [  \-v | \-\-verbose  ]
+.RB [  \-V | \-\-version ]    
+.RB [  \-w | \-\-where= ]
+.RB [ \-\-delayed ]
+.RB [ \-e | \-\-extended-insert ]
+.RB [ \-\-fields\-terminated\-by=... ]
+.RB [ \-\-fields\-enclosed\-by=... ]
+.RB [ \-\-fields-optionally\-enclosed\-by=... ]
+.RB [ \-\-fields\-escaped\-by=... ]
+.RB [ \-\-lines\-terminated\-by=... ]
+.RB [ \-v | \-\-verbose ]
+.RB [ \-V | \-\-version ]
+.RB [ "\-O net_buffer_length=#, where # < 16M" ]
+.SH DESCRIPTION
+Dumping definition and data mysql database or table
+.IR mysqldump
+supports by executing 
+.TP 
+.BR  \-A | \-\-all\-databases 
+Dump all the databases. This will be same as
+.BR\-\-databases 
+with all databases selected.
+.TP                        
+.BR    \-a | \-\-all
+Include all MySQL specific create options.
+.TP  
+.BR   \-# | \-\-debug=...
+Output debug log. Often this is 'd:t:o,filename`.
+.TP  
+.BR    \-\-character\-sets\-dir=...
+Directory where character sets are
+.TP 
+.BR    \-? | \-\-help
+Display this help message and exit.
+.TP  
+.BR \-B | \-\-databases
+To dump several databases. Note the difference in
+usage; In this case no tables are given. All name
+arguments are regarded as databasenames.
+'USE db_name;' will be included in the output
+.TP  
+.BR    \-c | \-\-complete\-insert 
+Use complete insert statements.
+.TP  
+.BR    \-C | \-\-compress 
+Use compression in server/client protocol.
+.TP  
+.BR    \-\-default\-character\-set=...
+Set the default character set
+.TP  
+.BR    \-e | \-\-extended\-insert 
+Allows utilization of the new, much faster
+INSERT syntax.
+.TP  
+.BR    \-\-add\-drop\-table
+Add a 'drop table' before each create.
+.TP  
+.BR    \-\-add\-locks
+Add locks around insert statements.
+.TP  
+.BR    \-\-allow\-keywords 
+Allow creation of column names that are keywords.
+.TP  
+.BR    \-\-delayed\-insert
+Insert rows with INSERT DELAYED.
+.TP  
+.BR    \-F | \-\-flush\-logs
+Flush logs file in server before starting dump.
+.TP  
+.BR    \-f | \-\-force 
+Continue even if we get an sql\-error.
+.TP  
+.BR    \-h | \-\-host=...
+Connect to host.
+.TP  
+.BR    \-l | \-\-lock\-tables
+Lock all tables for read.
+.TP  
+.BR    \-n | \-\-no\-create\-db 
+'CREATE DATABASE /*!32312 IF NOT EXISTS*/ db_name;'
+will not be put in the output. The above line will
+be added otherwise, if 
+.BR \-\-databases 
+or
+.BR \-\-all\-databases 
+option was given.
+.TP  
+.BR    \-t | \-\-no\-create\-info  
+Don't write table creation info.
+.TP  
+.BR    \-d | \-\-no\-data
+No row information.
+.TP  
+.BR    \-O | "\-\-set\-variable var=option"
+give a variable a value. 
+.BR \-\-help 
+lists variables
+.TP  
+.BR   \-\-opt
+Same as 
+.BR " \-\-add\-drop\-table \-\-add\-locks \-\-all \-\-extended\-insert \-\-quick \-\-lock\-tables "
+.TP  
+.BR    \-p | \-\-password[=...]  
+Password to use when connecting to server.
+If password is not given it's solicited on the tty.
+.TP  
+.BR    \-P | \-\-port=...
+Port number to use for connection.
+.TP  
+.BR    \-q | \-\-quick 
+Don't buffer query, dump directly to stdout.
+.TP  
+.BR    \-Q | \-\-quote\-names
+Quote table and column names with `
+.TP  
+.BR \-S | \-\-socket=...
+Socket file to use for connection.
+.TP  
+.BR    \-\-tables
+\fP\fIOverrides \fPoption 
+.BR \-\-databases (\-B).
+.TP  
+.BR    \-T | \-\-tab=...
+Creates tab separated textfile for each table to
+given path. (creates .sql and .txt files).
+NOTE: This only works if mysqldump is run on
+the same machine as the mysqld daemon.
+.TP  
+.BR    \-u | \-\-user=#  
+User for login if not current user.
+.TP  
+.BR    \-v | \-\-verbose 
+Print info about the various stages.
+.TP  
+.BR    \-V | \-\-version   
+Output version information and exit.
+.TP  
+.BR    \-w | \-\-where=    
+dump only selected records; QUOTES mandatory!
+.TP 
+.BR \-\-delayed 
+Insert rows with the INSERT DELAYED command. 
+.TP 
+.BR \-e | \-\-extended-insert 
+Use the new multiline INSERT syntax. (Gives more compact and faster inserts statements.) 
+.TP 
+.BR \-\-fields\-terminated\-by=... 
+.TP 
+.BR \-\-fields\-enclosed\-by=... 
+.TP 
+.TP 
+.BR \-\-fields-optionally\-enclosed\-by=... 
+.TP 
+.BR \-\-fields\-escaped\-by=... 
+.TP 
+.BR \-\-lines\-terminated\-by=... 
+These options are used with the 
+.BR -T 
+option and have the same meaning as the corresponding clauses for LOAD DATA INFILE. See Mysql manual section 7.23 LOAD DATA INFILE Syntax. 
+.TP 
+.BR \-v | \-\-verbose 
+Verbose mode. Print out more information on what the program does. 
+.TP 
+.BR \-V | \-\-version 
+Print version information and exit. 
+.TP 
+.BR "\-O net_buffer_length=#, where # < 16M "
+When creating multi-row-insert statements (as with option 
+.BR --extended-insert 
+or 
+.BR --opt
+), mysqldump will create rows up to net_buffer_length length. If you increase this variable, you should also ensure that the max_allowed_packet variable in the MySQL server is bigger than the net_buffer_length. 
+.SH EXAMPLES
+.TP
+The most normal use of mysqldump is probably for making a backup of whole databases. See Mysql Manual section 21.2 Database Backups. 
+.TP
+mysqldump  \-\-opt \fP\fIdatabase\fP > backup-file.sql
+.TP
+You can read this back into MySQL with: 
+.TP
+.BR mysql 
+\fP\fIdatabase\fP 
+.BR < 
+backup-file.sql
+.TP
+or 
+.TP
+.BR mysql 
+\-e 'source /patch\-to\-backup/backup\-file.sql' database
+.TP
+However, it's also very useful to populate another MySQL server with information from a database: 
+.TP
+mysqldump \-\-opt \fP\fIdatabase\fP | mysql \-\-host=\fP\fIremote\-host\fP \-C database
+.TP
+It is possible to dump several databases with one command: 
+.TP
+mysqldump \-\-databases database1 [ database2 database3... ]  > my_databases.sql
+.TP
+If all the databases are wanted, one can use: 
+.TP
+mysqldump \fP\fI\-\-all\-databases\fP > all_databases.sql
+
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+.\" end of man page
\ No newline at end of file
diff --git a/man/mysqlshow.1 b/man/mysqlshow.1
new file mode 100755
index 00000000000..55a87c1df78
--- /dev/null
+++ b/man/mysqlshow.1
@@ -0,0 +1,93 @@
+.TH MYSQLSHOW 1 "19 December 2000"
+.SH NAME
+.BR mysqlshow
+ \- Shows the structure of a mysql database (databases,tables and columns)
+.SH USAGE
+shell> mysqlshow [\fP\fIOPTIONS\fP] [\fP\fIdatabase [table [column]]\fP]
+.SH SYNOPSIS
+.B mysqlshow
+.RB [ \-# | \-\-debug=...]
+.RB [  \-? | \-\-help ]
+.RB [  \-c |  \-\-character\-sets\-dir=...]
+.RB [  \-C | \-\-compress  ]
+.RB [  \-h | \-\-host=... ]
+.RB [  \-i | \-\-status ]
+.RB [  \-k | \-\-keys ]
+.RB [  \-p |  \-\-password\fP\fI[=...]\fP ]
+.RB [  \-P |  \-\-port=...  ]
+.RB [  \-S |  \-\-socket=... ]
+.RB [  \-u |  \-\-user=# ]
+.RB [  \-V |  \-\-version ]
+.SH DESCRIPTION
+.TP
+.BR \-# | \-\-debug=...
+output debug log. Often this is 'd:t:o,filename`
+.TP
+.BR  \-? | \-\-help
+display help and exit
+.TP
+.BR  \-c | \-\-character\-sets\-dir=...
+Directory where character sets are
+.TP
+.BR  \-C | \-\-compress
+Use compression in server/client protocol
+.TP
+.BR \-h | \-\-host=...
+connect to host
+.TP
+.BR  \-i | \-\-status 
+Shows a lot of extra information about each table
+.TP
+.BR  \-k | \-\-keys 
+show keys for table
+.TP
+.BR \-p | \-\-password \fP\fI[=...] \fP 
+password to use when connecting to server
+If password is not given it's asked from the tty.
+.TP 
+.BR  \-P | \-\-port=...
+Port number to use for connection
+.TP
+.BR \-S | \-\-socket=...
+Socket file to use for connection
+.TP
+.BR  \-u | \-\-user=#
+user for login if not current user
+.TP 
+.BR  \-V | \-\-version
+output version information and exit  
+
+
+.SH NOTE
+If last argument contains a shell or SQL wildcard (*,?,% or _) then only
+what's matched by the wildcard is shown.
+If no database is given then all matching databases are shown.
+If no table is given then all matching tables in database are shown
+If no column is given then all matching columns and columntypes in table
+are shown
+
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill\-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+.\" end of man page
diff --git a/man/perror.1 b/man/perror.1
new file mode 100755
index 00000000000..2853f2cb1ba
--- /dev/null
+++ b/man/perror.1
@@ -0,0 +1,58 @@
+.TH PERROR 1 "19 December 2000"
+.SH NAME
+.BR perror
+can be used to display a description for a system error code, or an MyISAM/ISAM table handler error code. The error messages are mostly system dependent. 
+.SH USAGE
+perror [OPTIONS] [ERRORCODE [ERRORCODE...]]
+.SH SYNOPSIS
+.B perror
+.RB [ \-? | \-\-help ]
+.RB [ \-I | \-\-info ]
+.RB [ \-s | \-\-silent ]
+.RB [ \-v | \-\-verbose ]
+.RB [ \-V | \-\-version ]
+.SH DESCRIPTION
+.TP 
+.BR  \-? | \-\-help    
+Displays this help and exits.
+.TP 
+.BR  \-I | \-\-info  
+Synonym for the above.
+.TP 
+.BR    \-s | \-\-silent 
+Only print the error message
+.TP 
+.BR    \-v | \-\-verbose
+Print error code and message (default).
+.TP 
+.BR \-V | \-\-version  
+Displays version information and exits.
+.SH EXAMPLE
+shell> perror 64 79
+Error code  64:  Machine is not on the network
+Error code  79:  Can not access a needed shared library
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill\-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+.\" end of man page
diff --git a/man/replace.1 b/man/replace.1
new file mode 100644
index 00000000000..10bcf64fc88
--- /dev/null
+++ b/man/replace.1
@@ -0,0 +1,68 @@
+.TH REPLACE 1 "20 December 2000" 
+.SH NAME 
+.TP
+replace - A utility program that is used by msql2mysql, but that has more general applicability as well. replace changes strings in place in files or on the standard input. Uses a finite state machine to match longer strings first. Can be used to swap strings.
+.SH USAGE 
+replace [-?svIV] from to from to ... -- [files]
+.TP
+or
+.TP
+replace [-?svIV] from to from to ... < fromfile > tofile
+.SH SYNOPSIS 
+.B replace 
+.RB [ -?  |  -I ] 
+.RB [ -s ] 
+.RB [ -v ] 
+.SH DESCRIPTION 
+.TP
+.BR replace
+.TP
+.BR -?  |  -I
+info
+.TP
+.BR -s
+silent
+.TP
+.BR -v
+verbose
+.SH EXTRA INFO
+.B Special characters in from string:
+.TP
+\\^
+Match start of line.
+.TP
+\\$
+Match end of line.
+.TP
+\\b
+Match space-character, start of line or end of line. For a end \\b the next replace starts locking at the end space-character. A \\b alone in a string matches only a space-character.
+.SH EXAMPLE
+this command swaps a and b in the given files:
+.TP
+shell> replace a b b a -- file1 file2 ...
+.SH "SEE ALSO" 
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR 
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+.\" end of man page
+
+
diff --git a/man/safe_mysqld.1 b/man/safe_mysqld.1
new file mode 100755
index 00000000000..30abf04ae6b
--- /dev/null
+++ b/man/safe_mysqld.1
@@ -0,0 +1,86 @@
+.TH SAFE_MYSQLD	  1 "19 December 2000"
+.SH NAME
+.BR safe_mysqld
+is the recommended way to start a mysqld daemon on Unix. safe_mysqld adds some safety features such as restarting the server when an error occurs and logging run-time information to a log file. 
+.SH SYNOPSIS
+.B safe_mysqld
+.RB [ \-\-basedir=\fP\fIpath\fP ]
+.RB [ \-\-core\-file\-size=# ]
+.RB [ \-\-defaults\-extra\-file=\fP\fIpath\fP ]
+.RB [ \-\-defaults\-file=\fP\fIpath\fP ]
+.RB [ \-\-open\-files=# ]
+.RB [ \-\-datadir=\fP\fIpath\fP ]
+.RB [ \-\-err\-log=\fP\fIpath \fP]
+.RB [ \-\-ledir=path ]
+.RB [ \-\-log=\fP\fIpath\fP ]
+.RB [ \-\-no\-defaults ]
+.RB [ \-\-open\-files=# ]
+.RB [ \-\-pid\-file=\fP\fIpath\fP ]
+.RB [ \-\-port=# ]
+.RB [ \-\-socket=\fP\fIpath\fP ]
+.RB [ \-\-timezone=# ]
+.RB [ \-\-user=# ]
+.SH DESCRIPTION
+.TP 
+.BR \-\-basedir=\fP\fIpath \fP
+.TP 
+.BR \-\-core\-file\-size=# 
+.TP 
+.BR \-\-defaults\-extra\-file=\fP\fIpath \fP
+.TP 
+.BR \-\-defaults\-file=\fP\fIpath \fP
+.TP 
+.BR \-\-open\-files=# 
+Size of the core file mysqld should be able to create. Passed to ulimit \-c. 
+.TP 
+.BR \-\-datadir=\fP\fIpath \fP
+.TP 
+.BR \-\-err\-log=\fP\fIpath \fP
+.TP 
+.BR \-\-ledir=\fP\fIpath \fP
+Path to mysqld 
+.TP 
+.BR \-\-log=\fP\fIpath \fP
+.TP 
+.BR \-\-no\-defaults 
+.TP 
+.BR \-\-open\-files=# 
+Number of files mysqld should be able to open. Passed to ulimit \-n. 
+.TP 
+.BR \-\-pid\-file=\fP\fIpath \fP
+.TP 
+.BR \-\-port=# 
+.TP 
+.BR \-\-socket=\fP\fIpath \fP
+.TP 
+.BR \-\-timezone=# 
+Set the timezone (the TZ) variable to the value of this parameter. 
+.TP 
+.BR \-\-user=# 
+.SH NOTE
+Note that all options on the command line to safe_mysqld are passed to mysqld. If you wants to use any options in safe_mysqld that mysqld doesn't support, you must specify these in the option file. 
+.SH "SEE ALSO"
+isamchk (1),
+isamlog (1),
+mysqlaccess (1),
+mysqladmin (1),
+mysqlbug (1),
+mysqld (1),
+mysqldump (1),
+mysqlshow (1),
+msql2mysql (1),
+perror (1),
+replace (1),
+safe_mysqld (1),
+which1 (1),
+zap (1),
+.SH AUTHOR
+Ver 1.0, distribution 3.23.29a
+Michael (Monty) Widenius (monty@tcx.se),
+TCX Datakonsult AB (http://www.tcx.se).
+This software comes with no warranty.
+Manual page by L. (Kill-9) Pedersen 
+(kill-9@kill\-9.dk), Mercurmedia Data Model Architect /
+system developer (http://www.mercurmedia.com)
+
+.\" end of man page
diff --git a/man/which.2 b/man/which.2
new file mode 100644
index 00000000000..599b68080a2
--- /dev/null
+++ b/man/which.2
@@ -0,0 +1,54 @@
+.TH WHICH 1 "20 December 2000" 
+.SH NAME 
+which - Jani please supply one. 
+.SH USAGE 
+which [options] [--] programname [...]
+.SH SYNOPSIS 
+.B which 
+.RB [ \-\-version | \-[vV] ] 
+.RB [ \-\-skip\-dot ] 
+.RB [ \-\-skip\-tilde ] 
+.RB [ \-\-show\-dot ] 
+.RB [ \-\-show\-tilde ] 
+.RB [ \-\-tty\-only ] 
+.RB [ \-\-all | \-a ] 
+.RB [ \-\-read\-alias | \-i ] 
+.RB [ \-\-skip\-alias ] 
+.SH DESCRIPTION 
+.TP
+.BR which
+supports by executing
+.TP
+.BR \-\-version | \-[vV]
+Print version and exit successfully.
+.TP
+.BR \-\-skip\-dot
+Skip directories in PATH that start with a dot.
+.TP
+.BR \-\-skip\-tilde
+Skip directories in PATH that start with a tilde.
+.TP
+.BR \-\-show\-dot
+Don\'t expand a dot to current directory in output.
+.TP
+.BR \-\-show\-tilde
+Output a tilde for HOME directory for non-root.
+.TP
+.BR \-\-tty\-only 
+Stop processing options on the right if not on tty.
+.TP
+.BR \-\-all | \-a 
+Print all matches in PATH, not just the first
+.TP
+.BR \-\-read\-alias | \-i
+Read list of aliases from stdin.
+.TP
+.BR \-\-skip\-alias
+Ignore option 
+.BR --read-alias; 
+don\'t read stdin.
+.SH "SEE ALSO" 
+isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1), replace (1), safe_mysqld (1), which1 (1), zap (1),
+.SH AUTHOR 
+Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurmedia.com) 
+.\" end of man page 
\ No newline at end of file