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)

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

       mysqldump [OPTIONS] database [tables]

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

       OR     mysqldump [OPTIONS] --all-databases [OPTIONS]

       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]

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

              Dump all the databases. This will be same  as  --databases  with
              all databases selected.

              Include all MySQL specific create options.

              Output debug log. Often this is 'd:t:o,filename`.

              Directory where character sets are

              Display this help message and exit.

              To dump several databases. Note the difference in(1,8) usage; In this
              case no tables are given. All name  arguments  are  regarded  as

              Use complete insert statements.

              Use compression in(1,8) server/client protocol.

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

              Allows utilization of the new, much faster INSERT syntax.

              Add a 'drop table' before each create.

              Add locks around insert statements.

              Allow creation of column names that are keywords.

              Insert rows with INSERT DELAYED.

              Flush logs file(1,n) in(1,8) server before starting dump.

              Continue even if(3,n) we get an sql-error.

              Connect to host.

              Lock all tables for read.

              '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.

              Don't write(1,2) table creation info.

              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

              Password to use when connecting to server.  If password  is  not
              given it's solicited on the tty.

              Port number to use for connection.

              Don't buffer query, dump directly to stdout.

              Quote table and column names with `

              Socket file(1,n) to use for connection.

              Overrides option --databases(-B).

              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.

              User for login(1,3,5) if(3,n) not current user.

              Print info(1,5,n) about the various stages.

              Output version(1,3,5) information and exit.

              dump only selected records; QUOTES mandatory!

              Insert rows with the INSERT DELAYED command.

              Use  the  new  multiline  INSERT syntax. (Gives more compact and
              faster inserts statements.)





              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

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

              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.

       The most normal use of mysqldump is probably for making a backup
       of whole databases. See Mysql Manual section 21.2 Database Back-

       mysqldump  --opt database > backup-file.sql

       You can read(2,n,1 builtins) this back into MySQL with:

       mysql  database < backup-file.sql


       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... ]  >

       If all the databases are wanted, one can use:

       mysqldump --all-databases > all_databases.sql

       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),

       For more information please refer to the MySQL reference manual,
       which  may already be installed locally and which is also avail-
       able online at

       Please refer to to report bugs.

       Ver  1.0,   distribution   4.0.21   Michael   (Monty)   Widenius
       (, MySQL AB (  This soft-
       ware comes with no warranty.  Manual page by L. (Kill-9)  Peder-
       sen  (, Mercurmedia Data Model Architect / sys-
       tem developer (

MySQL 4.0                      19 December 2000                   mysqldump(1)

References for this manual (incoming links)