Seth Woolley's Man Viewer

mysqldump(1) - mysqldump - text-based client for dumping or backing up mysql databases, tables and or data - man 1 mysqldump

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

mysqldump(1)                    MySQL database                    mysqldump(1)



NAME
       mysqldump  -  text-based  client  for dumping or backing up mysql data-
       bases, 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
       mysqldump [-A|--all-databases] [-a|--all] [-#|--debug=...]   [--charac-
       ter-sets-dir=...]   [-?|--help] [-B|--databases] [-c|--complete-insert]
       [-C|--compress]  [--default-character-set=...]   [-e|--extended-insert]
       [--add-drop-table]  [--add-locks] [--allow-keywords] [--delayed-insert]
       [-F|--flush-logs]  [-f|--force]   [-h|--host=...]    [-l|--lock-tables]
       [-n|--no-create-db]   [-t|--no-create-info]  [-d|--no-data]  [-O|--set-
       variablevar=option]  [--opt]   [-p|--password[=...]]    [-P|--port=...]
       [-q|--quick]     [-Q|--quote-names]    [-S|--socket=...]     [--tables]
       [-T|--tab=...]      [-u|--user=#]     [-v|--verbose]     [-V|--version]
       [-w|--where=]   [--delayed]   [-e|--extended-insert]   [--fields-termi-
       nated-by=...]       [--fields-enclosed-by=...]        [--fields-option-
       ally-enclosed-by=...]     [--fields-escaped-by=...]     [--lines-termi-
       nated-by=...]  [-v|--verbose] [-V|--version]  [-O  net_buffer_length=#,
       where # < 16M]

DESCRIPTION
       Dumping  definition and data mysql database or table mysqldump supports
       by executing

       -A|--all-databases
              Dump all the databases. This will be same  as  --databases  with
              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 in(1,8) usage; In this
              case no tables are given. All name  arguments  are  regarded  as
              databasenames.

       -c|--complete-insert
              Use complete insert statements.

       -C|--compress
              Use compression in(1,8) server/client protocol.

       --default-character-set=...
              Set the default character set(7,n,1 builtins)

       -e|--extended-insert
              Allows utilization of the new, much faster INSERT 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(1,n) in(1,8) server before starting dump.

       -f|--force
              Continue even if(3,n) 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(1,8) the output. The above line will be  added  otherwise,  if(3,n)
              --databases or --all-databases option was given.

       -t|--no-create-info
              Don't write(1,2) table creation info.

       -d|--no-data
              No row information.

       -O|--set-variable var=option
              give a variable a value.  --help lists 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(1,n) to use for connection.

       --tables
              Overrides option --databases(-B).

       -T|--tab=...
              Creates  tab  separated  textfile  for each table to given path.
              (creates .sql and .txt files).  NOTE: This only works if(3,n)  mysql-
              dump is run on the same machine as the mysqld daemon.

       -u|--user=#
              User for login(1,3,5) if(3,n) not current user.

       -v|--verbose
              Print info(1,5,n) about the various stages.

       -V|--version
              Output version(1,3,5) 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 -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.

       -v|--verbose
              Verbose mode. Print out more information on what the pro-
              gram does.

       -V|--version
              Print version(1,3,5) information and exit.

       -O net_buffer_length=#, where # < 16M
              When creating multi-row-insert statements (as with option
              --extended-insert  or --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(1,8) 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 Back-
       ups.

       mysqldump  --opt database > backup-file.sql

       You can read(2,n,1 builtins) 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


SEE ALSO
       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1),
       mysqld(1),  mysqld_multi(1),  mysqld_safe(1),   mysql_fix_privi-
       lege_tables(1),     mysqlshow(1),    mysql_zap(1),    perror(1,3)(1),
       replace(1)

       For more information please refer to the MySQL reference manual,
       which  may already be installed locally and which is also avail-
       able online at http://www.mysql.com/doc/en/

BUGS
       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR
       Ver  1.0,   distribution   4.0.21   Michael   (Monty)   Widenius
       (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This soft-
       ware comes with no warranty.  Manual page by L. (Kill-9)  Peder-
       sen  (kill-9@kill-9.dk), Mercurmedia Data Model Architect / sys-
       tem developer (http://www.mercurmedia.com)




MySQL 4.0                      19 December 2000                   mysqldump(1)

References for this manual (incoming links)