summaryrefslogtreecommitdiff
path: root/man/mysqldump.1
diff options
context:
space:
mode:
authorunknown <lenz@mysql.com>2004-01-20 17:14:02 +0100
committerunknown <lenz@mysql.com>2004-01-20 17:14:02 +0100
commitefa80e01a4ca410723dd8bf185e84e4d6ed02359 (patch)
tree627e2ebc8c0a3f144a00460986beef6696124786 /man/mysqldump.1
parent36d82d189a258989a3c4cfdecc2011e240f65cdb (diff)
downloadmariadb-git-efa80e01a4ca410723dd8bf185e84e4d6ed02359.tar.gz
What started as an attempt to fix BUG#2270 (Substitute paths in mysql
manpage) turned out as a major overhaul of all man pages: - renamed all *.1 files to *.1.in to act as templates which are being processed at build time - replaced some hard-coded values with place holder that are being replaced with the proper values at build time - Updated list of available man pages in the SEE ALSO section and added a hint to the manual for more details - Added a BUGS section to all pages, referring to the bugs DB - Updated some obsolete URLs and mail addresses The actual content of these man pages should probably be cross-checked for correctness, though... man/Makefile.am: - Replace some hard-coded values in the man pages with the proper values at build time instead. Instead of the *.1 files, we now add the *.1.in files (the templates) to the source distribution and generate the *.1 files during make. man/isamchk.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/isamlog.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysql_fix_privilege_tables.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysql_zap.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysqlaccess.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysqladmin.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysqld.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysqld_multi.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysqld_safe.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysqldump.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysqlshow.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/perror.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/replace.1.in: - replaced some hard-coded values (e.g. Version numbers) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address man/mysql.1.in: - replaced some hard-coded values (e.g. Version numbers, path names) with variables which are replaced with the proper values at build time - Updated list of other man pages listed in SEE ALSO - Added BUGS section, referring to the bugs database - Updated URL and Mail address
Diffstat (limited to 'man/mysqldump.1')
-rw-r--r--man/mysqldump.1273
1 files changed, 0 insertions, 273 deletions
diff --git a/man/mysqldump.1 b/man/mysqldump.1
deleted file mode 100644
index 6907fcc8777..00000000000
--- a/man/mysqldump.1
+++ /dev/null
@@ -1,273 +0,0 @@
-.TH mysqldump 1 "19 December 2000" "MySQL 4.0" "MySQL database"
-.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),
-mysqld_safe (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