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

 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

Glossary
MoreInfo
Man Pages
Linux Topics
Test Your Knowledge

Site Menu
Site Map
FAQ
Copyright Info
Terms of Use
Privacy Info
Disclaimer
WorkBoard
Thanks
Donations
Advertising
Masthead / Impressum
Your Account

Communication
Feedback
Forums
Private Messages
Surveys

Features
HOWTOs
News Archive
Submit News
Topics
User Articles
Web Links

Google
Google


The Web
linux-tutorial.info

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

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

  

mysqldump




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=...]
       [--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-optionally-enclosed-by=...]
       [--fields-escaped-by=...]      [--lines-terminated-by=...]
       [-v|--verbose]  [-V|--version]  [-O   net_buffer_length=#,
       where # < 16M]


DESCRIPTION

       Dumping definition and data mysql database or table mysql­
       dump 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
              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 will
              be   added    otherwise,    if    --databases    or
              --all-databases option 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.  --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
              This  only  works  if  mysqldump is run on the 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 -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.

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


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

MySQL 4.0                19 December 2000            mysqldump(1)
  




Login
Nickname

Password

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 get all the latest Site and Linux news by checking out our news page.


Friends



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.04 Seconds