Web Hosting Web Hosting, web hosting, JSP, Servlets, Tomcat, website hosting, web site hosting
Web Hosting, web hosting, JSP, Servlets, Tomcat, website hosting, web site hosting
Web Hosting, web hosting, JSP, Servlets, Tomcat, website hosting, web site hosting

Alden Hosting provides professional, efficient, and reliable business-class Web hosting and Website Design services.

WWW.

Call Us Toll-Free
(877) 256-0328

Outside USA
1 - (201) 505-0430

WELCOME HOSTING PLANS FUND RAISING RESELLERS WEB DESIGN EXTRA SERVICES SITE STUDIO TRAFFIC BOOSTER TECH SUPPORT WEBMASTER TIPS 30 DAY GUARANTEE LEGAL NOTICES GLOSSARY CONTACT INFO TECH NEWS

Site Map

LINUX Web Hosting Commands and tools 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),  mysql(1),  mysqlaccess(1),
       mysqladmin(1),      mysqld(1),     mysqld_multi(1),
       mysqld_safe(1),      mysql_fix_privilege_tables(1),
       mysqlshow(1), mysql_zap(1), perror(1), replace(1)

       For more information please refer to the MySQL ref-
       erence  manual,  which  may  already  be  installed
       locally  and  which  is  also  available  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.1.10 Michael (Monty) Wide-
       nius       (monty@mysql.com),       MySQL        AB
       (http://www.mysql.com/).   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.1                19 December 2000            mysqldump(1)

Web Hosting, web hosting, JSP, Servlets, Tomcat, website hosting, web site hosting
Add to My Yahoo!

XML icon

Add to Google

 

 

 

 

 

 

 

 

 

 

 

http://alden-servlet-Hosting.com
JSP at alden-servlet-Hosting.com
Servlets at alden-servlet-Hosting.com
Servlet at alden-servlet-Hosting.com
Tomcat at alden-servlet-Hosting.com
MySQL at alden-servlet-Hosting.com
Java at alden-servlet-Hosting.com
sFTP at alden-servlet-Hosting.com
http://alden-tomcat-Hosting.com
JSP at alden-tomcat-Hosting.com
Servlets at alden-tomcat-Hosting.com
Servlet at alden-tomcat-Hosting.com
Tomcat at alden-tomcat-Hosting.com
MySQL at alden-tomcat-Hosting.com
Java at alden-tomcat-Hosting.com
sFTP at alden-tomcat-Hosting.com
http://alden-sftp-Hosting.com
JSP at alden-sftp-Hosting.com
Servlets at alden-sftp-Hosting.com
Servlet at alden-sftp-Hosting.com
Tomcat at alden-sftp-Hosting.com
MySQL at alden-sftp-Hosting.com
Java at alden-sftp-Hosting.com
sFTP at alden-sftp-Hosting.com
http://alden-jsp-Hosting.com
JSP at alden-jsp-Hosting.com
Servlets at alden-jsp-Hosting.com
Servlet at alden-jsp-Hosting.com
Tomcat at alden-jsp-Hosting.com
MySQL at alden-jsp-Hosting.com
Java at alden-jsp-Hosting.com
sFTP at alden-jsp-Hosting.com
http://alden-java-Hosting.com
JSp at alden-java-Hosting.com
Servlets at alden-java-Hosting.com
Servlet at alden-java-Hosting.com
Tomcat at alden-java-Hosting.com
MySQL at alden-java-Hosting.com
Java at alden-java-Hosting.com
sFTP at alden-java-Hosting.com
JSP Servlets Tomcat mysql Java JSP Servlets Tomcat mysql Java JSP Servlets Tomcat mysql Java JSP Servlets Tomcat mysql Java JSP at JSP.aldenWEBhosting.com Servlets at servlets.aldenWEBhosting.com Tomcat at Tomcat.aldenWEBhosting.com mysql at mysql.aldenWEBhosting.com Java at Java.aldenWEBhosting.com Web Hosts Portal Web Links Web Links JSP Web Links servlet Tomcat Docs Web Links Web Links JSP Web Links servlet Web Hosting Tomcat Docs JSP Solutions Web Links JSP Solutions Web Hosting Servlets Solutions Web Links Servlets Solutions Web Hosting Web Links Web Links . .
.
.
. .
. . . . jsp hosting servlets hosting web hosting web sites designed cheap web hosting web site hosting myspace web hosting