Welcome to Linux Knowledge Base and Tutorial
"The place where you learn linux"

 Create an AccountHome | Submit News | Your Account  

Tutorial Menu
Linux Tutorial Home
Table of Contents

· Introduction to Operating Systems
· Linux Basics
· Working with the System
· Shells and Utilities
· Editing Files
· Basic Administration
· The Operating System
· The X Windowing System
· The Computer Itself
· Networking
· System Monitoring
· Solving Problems
· Security
· Installing and Upgrading
· Linux and Windows

Man Pages
Linux Topics
Test Your Knowledge

Site Menu
Site Map
Copyright Info
Terms of Use
Privacy Info
Masthead / Impressum
Your Account

Private Messages

News Archive
Submit News
User Articles
Web Links


The Web

Who's Online
There are currently, 58 guest(s) and 0 member(s) that are online.

You are an Anonymous user. You can register for free by clicking here




       mysqldump [OPTIONS] database [tables]

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

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


       mysqldump [-A|--all-databases] [-a|--all] [-#|--debug=...]
       [--character-sets-dir=...]   [-?|--help]  [-B|--databases]
       [-c|--complete-insert]  [-C|--compress] [--default-charac­
       ter-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|--ver­
       sion]  [-w|--where=]  [--delayed]   [-e|--extended-insert]
       [--fields-terminated-by=...]    [--fields-enclosed-by=...]
       [--fields-escaped-by=...]      [--lines-terminated-by=...]
       [-v|--verbose]  [-V|--version]  [-O   net_buffer_length=#,
       where # < 16M]


       Dumping definition and data mysql database or table mysql­
       dump 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

              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 in server before starting dump.

              Continue even if 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 the output. The above line will
              be   added    otherwise,    if    --databases    or
              --all-databases option was given.

              Don't write 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.

              This  only  works  if  mysqldump is run on the same
              machine as the mysqld daemon.

              User for login if not current user.

              Print info about the various stages.

              Output version 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 correspond­
              ing  clauses for LOAD DATA INFILE. See Mysql
              manual section 7.23 LOAD DATA INFILE Syntax.

              Verbose  mode. Print out more information on
              what the program does.

              Print version 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 the MySQL
              server is bigger than the net_buffer_length.

       mysql  -e 'source /patch-to-backup/backup-file.sql'

       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

       mysqldump   --databases   database1   [   database2
       database3... ]  > my_databases.sql

       If all the databases are wanted, one can use:

       mysqldump --all-databases > all_databases.sql


       isamchk (1), isamlog (1), mysqlaccess (1), mysqlad­
       min  (1),  mysqlbug (1), mysqld (1), mysqldump (1),
       mysqlshow (1), msql2mysql (1), perror (1),  replace
       (1), mysqld_safe (1), which1 (1), zap (1),


       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 Archi­
       tect  /  system   developer   (http://www.mercurme­

MySQL 4.0                19 December 2000            mysqldump(1)



Security Code
Security Code
Type Security Code

Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.

Help if you can!

Amazon Wish List

Did You Know?
You can help in many different ways.


Tell a Friend About Us

Bookmark and Share

Web site powered by PHP-Nuke

Is this information useful? At the very least you can help by spreading the word to your favorite newsgroups, mailing lists and forums.
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters. Articles are the property of their respective owners. Unless otherwise stated in the body of the article, article content (C) 1994-2013 by James Mohr. All rights reserved. The stylized page/paper, as well as the terms "The Linux Tutorial", "The Linux Server Tutorial", "The Linux Knowledge Base and Tutorial" and "The place where you learn Linux" are service marks of James Mohr. All rights reserved.
The Linux Knowledge Base and Tutorial may contain links to sites on the Internet, which are owned and operated by third parties. The Linux Tutorial is not responsible for the content of any such third-party site. By viewing/utilizing this web site, you have agreed to our disclaimer, terms of use and privacy policy. Use of automated download software ("harvesters") such as wget, httrack, etc. causes the site to quickly exceed its bandwidth limitation and are therefore expressly prohibited. For more details on this, take a look here

PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.09 Seconds