MAN page from Trustix mysql-client-3.23.58-3tr.i586.rpm

mysqldump

Section: MySQL database (1)
Updated: 19 December 2000
Index

NAME

mysqldump - text-based client for dumping or backing up mysql databases , tables and or data.

USAGE

mysqldump [OPTIONS] database [tables]

OR: mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR: mysqldump [OPTIONS] --all-databases [OPTIONS]

OPTION SYNOPSIS

DESCRIPTION

Dumping definition and data mysql database or tablemysqldumpsupports by executing

-A|--all-databases: Dump all the databases. This will be same as--databaseswith all databases selected.
-a|--all: Include all MySQL specific create options.
-#|--debug=...: Output debug log. Often this is 'd:t:o,filename`.
--character-sets-dir=...: Directory where character sets are
-?|--help: Display this help message and exit.
-B|--databases: To dump several databases. Note the difference inusage; In this case no tables are given. All namearguments are regarded as databasenames.
-c|--complete-insert: Use complete insert statements.
-C|--compress: Use compression in server/client protocol.
--default-character-set=...: Set the default character set
-e|--extended-insert: Allows utilization of the new, much fasterINSERT syntax.
--add-drop-table: Add a 'drop table' before each create.
--add-locks: Add locks around insert statements.
--allow-keywords: Allow creation of column names that are keywords.
--delayed-insert: Insert rows with INSERT DELAYED.
-F|--flush-logs: Flush logs file in server before starting dump.
-f|--force: Continue even if we get an sql-error.
-h|--host=...: Connect to host.
-l|--lock-tables: Lock all tables for read.
-n|--no-create-db: 'CREATE DATABASE /*!32312 IF NOT EXISTS*/ db_name;'will not be put in the output. The above line willbe added otherwise, if --databasesor--all-databasesoption was given.
-t|--no-create-info: Don't write table creation info.
-d|--no-data: No row information.
-O|--set-variable var=option: give a variable a value. --helplists variables
--opt: Same as --add-drop-table --add-locks --all --extended-insert --quick --lock-tables
-p|--password[=...]: Password to use when connecting to server.If password is not given it's solicited on the tty.
-P|--port=...: Port number to use for connection.
-q|--quick: Don't buffer query, dump directly to stdout.
-Q|--quote-names: Quote table and column names with `
-S|--socket=...: Socket file to use for connection.
--tables: Overrides option --databases(-B).
-T|--tab=...: Creates tab separated textfile for each table togiven path. (creates .sql and .txt files).NOTE: This only works if mysqldump is run onthe same machine as the mysqld daemon.
-u|--user=#: User for login if not current user.
-v|--verbose: Print info about the various stages.
-V|--version: Output version information and exit.
-w|--where=: dump only selected records; QUOTES mandatory!
--delayed: Insert rows with the INSERT DELAYED command.
-e|--extended-insert: Use the new multiline INSERT syntax. (Gives more compact and faster inserts statements.)
--fields-terminated-by=...
--fields-enclosed-by=...

--fields-optionally-enclosed-by=...
--fields-escaped-by=...
--lines-terminated-by=...: These options are used with the -Toption and have the same meaning as the corresponding clauses for LOAD DATA INFILE. See Mysql manual section 7.23 LOAD DATA INFILE Syntax.
-v|--verbose: Verbose mode. Print out more information on what the program does.
-V|--version: Print version information and exit.
-O net_buffer_length=#, where # < 16M: When creating multi-row-insert statements (as with option --extended-insertor --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.

EXAMPLES

The most normal use of mysqldump is probably for making a backup of whole databases. See Mysql Manual section 21.2 Database Backups.
mysqldump --opt database > backup-file.sql
You can read this back into MySQL with:
mysql: database <backup-file.sql
or
mysql: -e 'source /patch-to-backup/backup-file.sql' database
However, it's also very useful to populate another MySQL server with information from a database:
mysqldump --opt database | mysql --host=remote-host -C database
It is possible to dump several databases with one command:
mysqldump --databases database1 [ database2 database3... ] > my_databases.sql
If all the databases are wanted, one can use:
mysqldump --all-databases > all_databases.sql

AUTHOR

Ver 1.0, distribution 3.23.29aMichael (Monty) Widenius (montyAATTtcx.se),TCX Datakonsult AB (http://www.tcx.se).This software comes with no warranty.Manual page by L. (Kill-9) Pedersen (kill-9AATTkill-9.dk), Mercurmedia Data Model Architect /system developer (http://www.mercurmedia.com)

This document was created byman2html,using the manual pages.