|
|
JAVA, JSP, SERVLETS, TOMCAT, SERVLETS MANAGER,
Private JVM (Java Virtual Machine),
Private Tomcat Server
Alden Hosting offers private JVM (Java Virtual Machine), Java Server Pages (JSP), Servlets, and Servlets Manager with our Web Hosting Plans
WEB 4 PLAN and
WEB 5 PLAN ,
WEB 6 PLAN .
At Alden Hosting we eat and breathe Java! We are the industry leader in providing
affordable, quality and efficient Java web hosting in the shared hosting marketplace.
All our sites run on our Java hosing platform configured for
optimum performance using Java 1.6, Tomcat 6.0.X, MySQL 5.0.x, Apache 2.2.xx and web
application frameworks such as Struts, Hibernate, Cocoon, Ant, etc.
We offer only one type of Java hosting - Private Tomcat. Hosting accounts on the Private
Tomcat environment get their very own Tomcat server. You can start and re-start
your entire Tomcat server yourself.
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)
JAVA, JSP, SERVLETS, TOMCAT, SERVLETS MANAGER,
Private JVM (Java Virtual Machine),
Private Tomcat Server
Alden Hosting offers private JVM (Java Virtual Machine), Java Server Pages (JSP), Servlets, and Servlets Manager with our Web Hosting Plans
WEB 4 PLAN and
WEB 5 PLAN ,
WEB 6 PLAN .
At Alden Hosting we eat and breathe Java! We are the industry leader in providing
affordable, quality and efficient Java web hosting in the shared hosting marketplace.
All our sites run on our Java hosing platform configured for
optimum performance using Java 1.6, Tomcat 6.0.X, MySQL 5.0.x, Apache 2.2.xx and web
application frameworks such as Struts, Hibernate, Cocoon, Ant, etc.
We offer only one type of Java hosting - Private Tomcat. Hosting accounts on the Private
Tomcat environment get their very own Tomcat server. You can start and re-start
your entire Tomcat server yourself.
|
