MySql
- CssWork - parent
- SlashDocumentationIndex
- MySqlCribSheet - quick command reference
- SqlSchema - tables used in the database
- SqlDefaults - defaults for those tables
- DescriptionsOfVariablesInDatabaseTableVars
- http://dev.mysql.com/doc/refman/5.5/en/index.html
- http://dev.mysql.com/doc/refman/5.5/en/tutorial.html
as root: mysqldump altslashdot css > zz.txt
mysqldump -T '/var/lib/mysql/test' altslashdot css
Information about mysql as used for slash on slashcott
Database Name: altslashdot Database user: mysql
Version
mysql-5.5.36 db4-devel-4.7.25 mysql-libs-5.5.36 db4-utils-4.7.25 mysql-server-5.5.36
mysqldump
mysqldump http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html
A client that dumps a MySQL database into a file as SQL, text, or XML.
The mysqldump client is a utility that performs logical backups, producing a set of SQL statements that can be run to reproduce the original schema objects, table data, or both. It dumps one or more MySQL database for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML format.
Syntax There are in general three ways to use mysqldump—in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server—as shown here: shell> mysqldump [options] db_name [tbl_name ...] shell> mysqldump [options] --databases db_name ... shell> mysqldump [options] --all-databases
To dump entire databases, do not name any tables following db_name, or use the --databases or --all-databases option.
mysqldump does not dump the INFORMATION_SCHEMA database by default. mysqldump dumps INFORMATION_SCHEMA only if you name it explicitly on the command line, although currently you must also use the --skip-lock-tables option. Before MySQL 5.5 mysqldump silently ignores INFORMATION_SCHEMA even if you name it explicitly on the command line.
mysqldump does not dump the performance_schema database.
Before MySQL 5.5.25, mysqldump does not dump the general_log or slow_query_log tables for dumps of the mysql database. As of 5.5.25, the dump includes statements to recreate those tables so that they are not missing after reloading the dump file. Log table contents are not dumped.
mysqldump also does not dump the MySQL Cluster ndbinfo information database.
To see a list of the options your version of mysqldump supports, execute mysqldump --help.
ODD BEHAVIOR OF mysqldump:
Symptom - when using -T option, data seems in the wrong place, or extra fields seem to exist.
This seems to be caused by the fact that when you delete a field in a table, it is not really deleted, just removed from the schema. That data is still there,just can't be referenced by normal sql commands. But when mysqldump dumps a table in -T tabbed text form, it STILL dumps all the old data. The missing fields are effectively restored, and will cause off by one errors etc.
The logic of this escapes me, but there it is.
table dump for size deletemelater
[root@slashcode test]# ls -l | cut -b 28- | grep -v '\.sql' | sort -g
0 Mar 2 20:56 accesslog_artcom.txt
0 Mar 2 20:56 accesslog_temp_subscriber.txt
0 Mar 2 20:56 al2_log_comments.txt
0 Mar 2 20:56 al2_log.txt
0 Mar 2 20:56 auto_poll.txt
0 Mar 2 20:56 backup_blocks.txt
0 Mar 2 20:56 blobs.txt
0 Mar 2 20:56 bookmark_feeds.txt
0 Mar 2 20:56 bookmarks.txt
0 Mar 2 20:56 classes.txt
0 Mar 2 20:56 comment_log.txt
0 Mar 2 20:56 comment_promote_log.txt
0 Mar 2 20:56 comment_vote.txt
0 Mar 2 20:56 dbs_readerstatus_queries.txt
0 Mar 2 20:56 dbs_readerstatus.txt
0 Mar 2 20:56 dbs.txt
0 Mar 2 20:56 discussion_rating.txt
0 Mar 2 20:56 email_optout.txt
0 Mar 2 20:56 file_queue.txt
0 Mar 2 20:56 firehose_history.txt
0 Mar 2 20:56 firehose_section_settings.txt
0 Mar 2 20:56 firehose_section.txt
0 Mar 2 20:56 firehose_setting_log.txt
0 Mar 2 20:56 firehose_skin_volume.txt
0 Mar 2 20:56 firehose_view_settings.txt
0 Mar 2 20:56 globj_adminnotes.txt
0 Mar 2 20:56 globjs_viewed_archived.txt
0 Mar 2 20:56 globjs_viewed.txt
0 Mar 2 20:56 globj_urls.txt
0 Mar 2 20:56 humanconf_pool.txt
0 Mar 2 20:56 humanconf.txt
0 Mar 2 20:56 journal_transfer.txt
0 Mar 2 20:56 message_drop.txt
0 Mar 2 20:56 metamodlog.txt
0 Mar 2 20:56 misc_user_opts.txt
0 Mar 2 20:56 newsvac_keywords.txt
0 Mar 2 20:56 nugget_sub.txt
0 Mar 2 20:56 pagemark.txt
0 Mar 2 20:56 preview.txt
0 Mar 2 20:56 projects.txt
0 Mar 2 20:56 querylog.txt
0 Mar 2 20:56 related_stories.txt
0 Mar 2 20:56 rel.txt
0 Mar 2 20:56 remarks.txt
0 Mar 2 20:56 reskey_failures.txt
0 Mar 2 20:56 reskey_sessions.txt
0 Mar 2 20:56 robosubmitlock.txt
0 Mar 2 20:56 rss_raw.txt
0 Mar 2 20:56 sphinx_counter_archived.txt
0 Mar 2 20:56 sphinx_counter.txt
0 Mar 2 20:56 sphinx_search.txt
0 Mar 2 20:56 spiderlock.txt
0 Mar 2 20:56 spider_timespec.txt
0 Mar 2 20:56 static_files.txt
0 Mar 2 20:56 stats_graphs_index.txt
0 Mar 2 20:56 story_dirty.txt
0 Mar 2 20:56 story_files.txt
0 Mar 2 20:56 story_render_dirty.txt
0 Mar 2 20:56 submissions_notes.txt
0 Mar 2 20:56 subscribe_payments.txt
0 Mar 2 20:56 tagboxes.txt
0 Mar 2 20:56 tagboxlog_feeder.txt
0 Mar 2 20:56 tagcommand_adminlog_sfnet.txt
0 Mar 2 20:56 tagcommand_adminlog.txt
0 Mar 2 20:56 tagname_cache.txt
0 Mar 2 20:56 tagname_params.txt
0 Mar 2 20:56 tagnames_similarity_rendered.txt
0 Mar 2 20:56 tagnames_synonyms_chosen.txt
0 Mar 2 20:56 tag_params.txt
0 Mar 2 20:56 tags_dayofweek.txt
0 Mar 2 20:56 tags_deactivated.txt
0 Mar 2 20:56 tags_hourofday.txt
0 Mar 2 20:56 tags_peerweight.txt
0 Mar 2 20:56 tags_searched.txt
0 Mar 2 20:56 tags.txt
0 Mar 2 20:56 tags_userchange.txt
0 Mar 2 20:56 topic_nexus_dirty.txt
0 Mar 2 20:56 topic_nexus_extras.txt
0 Mar 2 20:56 topic_param.txt
0 Mar 2 20:56 url_content.txt
0 Mar 2 20:56 url_message_body.txt
0 Mar 2 20:56 url_plaintext.txt
0 Mar 2 20:56 urls.txt
0 Mar 2 20:56 users_acl.txt
0 Mar 2 20:56 users_clout.txt
0 Mar 2 20:56 users_comments_read_log.txt
0 Mar 2 20:56 users_openid_reskeys.txt
0 Mar 2 20:56 users_openid.txt
0 Mar 2 20:56 wow_char_armorylog.txt
0 Mar 2 20:56 wow_char_data.txt
0 Mar 2 20:56 wow_chars.txt
0 Mar 2 20:56 wow_guilds.txt
0 Mar 2 20:56 xsite_auth_log.txt
12 Mar 2 20:56 tagnames.txt
14 Mar 2 20:56 topic_nexus.txt
20 Mar 2 20:56 shill_ids.txt
22 Mar 2 20:56 accesslog_build_unique_uid.txt
36 Mar 2 20:56 message_deliverymodes.txt
41 Mar 2 20:56 al2.txt
42 Mar 2 20:56 journal_themes.txt
49 Mar 2 20:56 topic_parents.txt
66 Mar 2 20:56 commentmodes.txt
69 Mar 2 20:56 dynamic_blocks.txt
69 Mar 2 20:56 wow_char_types.txt
73 Mar 2 20:56 accesslog_temp_host_addr.txt
74 Mar 2 20:56 globj_types.txt
75 Mar 2 20:56 css_type.txt
81 Mar 2 20:56 open_proxies.txt
83 Mar 2 20:56 people.txt
86 Mar 2 20:56 discussion_kinds.txt
94 Mar 2 20:56 clout_types.txt
103 Mar 2 20:56 sphinx_index.txt
111 Mar 2 20:56 sessions.txt
114 Mar 2 20:56 dst.txt
116 Mar 2 20:56 pollvoters.txt
121 Mar 2 20:56 hooks.txt
136 Mar 2 20:56 authors_cache.txt
138 Mar 2 20:56 globjs.txt
144 Mar 2 20:56 story_topics_rendered.txt
163 Mar 2 20:56 humanconf_questions.txt
176 Mar 2 20:56 tags_udc.txt
187 Mar 2 20:56 story_topics_chosen.txt
198 Mar 2 20:56 url_info.txt
230 Mar 2 20:56 spamarmors.txt
272 Mar 2 20:56 al2_types.txt
280 Mar 2 20:56 modreasons.txt
311 Mar 2 20:56 bpn_sources.txt
333 Mar 2 20:56 skins.txt
344 Mar 2 20:56 moderatorlog.txt
353 Mar 2 20:56 submission_param.txt
371 Mar 2 20:56 pollquestions.txt
422 Mar 2 20:56 topics.txt
435 Mar 2 20:56 soap_methods.txt
468 Mar 2 20:56 reskey_resources.txt
488 Mar 2 20:56 journals.txt
489 Mar 2 20:56 preview_param.txt
495 Mar 2 20:56 accesslog_build_uidip.txt
540 Mar 2 20:56 skin_colors.txt
607 Mar 2 20:56 pollanswers.txt
616 Mar 2 20:56 badpasswords.txt
638 Mar 2 20:56 story_param.txt
658 Mar 2 20:56 message_codes.txt
706 Mar 2 20:56 related_links.txt
743 Mar 2 20:56 dateformats.txt
859 Mar 2 20:56 reskeys.txt
890 Mar 2 20:56 achievements.txt
972 Mar 2 20:56 signoff.txt
1018 Mar 2 20:56 users_prefs.txt
1122 Mar 2 20:56 css.txt
1294 Mar 2 20:56 ajax_ops.txt
1303 Mar 2 20:56 tzcodes.txt
1312 Mar 2 20:56 users_index.txt
1316 Mar 2 20:56 users_hits.txt
1529 Mar 2 20:56 message_web.txt
1543 Mar 2 20:56 user_achievement_streaks.txt
1778 Mar 2 20:56 code_param.txt
2047 Mar 2 20:56 content_filters.txt
2132 Mar 2 20:56 reskey_hourlysalt.txt
2163 Mar 2 20:56 stories.txt
2430 Mar 2 20:56 users_comments.txt
2951 Mar 2 20:56 site_info.txt
3180 Mar 2 20:56 users_messages.txt
3385 Mar 2 20:56 slashd_status.txt
3595 Mar 2 20:56 menus.txt
3784 Mar 2 20:56 discussions.txt
4048 Mar 2 20:56 abusers.txt
4087 Mar 2 20:56 user_achievements.txt
4507 Mar 2 20:56 uncommonstorywords.txt
5099 Mar 2 20:56 accesslog_temp_rss.txt
5330 Mar 2 20:56 users.txt
6469 Mar 2 20:56 reskey_vars.txt
6619 Mar 2 20:56 blocks.txt
7016 Mar 2 20:56 reskey_resource_checks.txt
7373 Mar 2 20:56 journals_text.txt
7613 Mar 2 20:56 users_logtokens.txt
9144 Mar 2 20:56 formkeys.txt
10087 Mar 2 20:56 users_param.txt
10099 Mar 2 20:56 message_web_text.txt
10570 Mar 2 20:56 string_param.txt
10691 Mar 2 20:56 users_info.txt
10809 Mar 2 20:56 wow_realms.txt
11398 Mar 2 20:56 comments.txt
13957 Mar 2 20:56 message_log.txt
14980 Mar 2 20:56 comment_text.txt
018561 Mar 2 20:56 accesslog_admin.txt
24852 Mar 2 20:56 accesslog_temp_other.txt
50104 Mar 2 20:56 vars.txt
57261 Mar 2 20:56 submissions.txt
68640 Mar 2 20:56 dynamic_user_blocks.txt
84260 Mar 2 20:56 story_text.txt
256371 Mar 2 20:56 slashd_errnotes.txt
283635 Mar 2 20:56 accesslog_temp_errors.txt
431983 Mar 2 20:56 accesslog_temp.txt
579455 Mar 2 20:56 accesslog.txt
869491 Mar 2 20:56 stats_daily.txt
917375 Mar 2 20:56 templates.txt
Mysql programs
All these try PROGNAME --help for details
also http://dev.mysql.com/doc/refman/5.5/en/programs-overview.html
The MySQL server, mysqld, is the main program that does most of the work in a MySQL installation. The server is accompanied by several related scripts that assist you in starting and stopping the server:
mysqld
The SQL daemon (that is, the MySQL server). To use client programs, mysqld must be running, because clients gain access to databases by connecting to the server. See Section 4.3.1, “mysqld — The MySQL Server”.
mysqld_safe
A server startup script. mysqld_safe attempts to start mysqld. See Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”.
mysql.server
A server startup script. This script is used on systems that use System V-style run directories containing scripts that start system services for particular run levels. It invokes mysqld_safe to start the MySQL server. See Section 4.3.3, “mysql.server — MySQL Server Startup Script”.
mysqld_multi
A server startup script that can start or stop multiple servers installed on the system. See Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”.
Several programs perform setup operations during MySQL installation or upgrading:
comp_err
This program is used during the MySQL build/installation process. It compiles error message files from the error source files. See Section 4.4.1, “comp_err — Compile MySQL Error Message File”.
mysql_install_db
This script creates the MySQL database and initializes the grant tables with default privileges. It is usually executed only once, when first installing MySQL on a system. See Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”, Section 2.10.1, “Postinstallation Procedures for Unix-like Systems”, and Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”.
mysql_plugin
This program configures MySQL server plugins. See Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”.
mysql_secure_installation
This program enables you to improve the security of your MySQL installation. SQL. See Section 4.4.5, “mysql_secure_installation — Improve MySQL Installation Security”.
mysql_tzinfo_to_sql
This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time zones). SQL. See Section 4.4.6, “mysql_tzinfo_to_sql — Load the Time Zone Tables”.
mysql_upgrade
This program is used after a MySQL upgrade operation. It checks tables for incompatibilities and repairs them if necessary, and updates the grant tables with any changes that have been made in newer versions of MySQL. See Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”.
MySQL client programs that connect to the MySQL server:
mysql
The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. See Section 4.5.1, “mysql — The MySQL Command-Line Tool”.
mysqladmin
A client that performs administrative operations, such as creating or dropping databases, reloading the grant tables, flushing tables to disk, and reopening log files. mysqladmin can also be used to retrieve version, process, and status information from the server. See Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”.
mysqlcheck
A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See Section 4.5.3, “mysqlcheck — A Table Maintenance Program”.
mysqldump
A client that dumps a MySQL database into a file as SQL, text, or XML. See Section 4.5.4, “mysqldump — A Database Backup Program”.
mysqlimport
A client that imports text files into their respective tables using LOAD DATA INFILE. See Section 4.5.5, “mysqlimport — A Data Import Program”.
mysqlshow
A client that displays information about databases, tables, columns, and indexes. See Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”.
mysqlslap
A client that is designed to emulate client load for a MySQL server and report the timing of each stage. It works as if multiple clients are accessing the server. See Section 4.5.7, “mysqlslap — Load Emulation Client”.
MySQL administrative and utility programs:
innochecksum
An offline InnoDB offline file checksum utility. See Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”.
myisam_ftdump
A utility that displays information about full-text indexes in MyISAM tables. See Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”.
myisamchk
A utility to describe, check, optimize, and repair MyISAM tables. See Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”.
myisamlog
A utility that processes the contents of a MyISAM log file. See Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”.
myisampack
A utility that compresses MyISAM tables to produce smaller read-only tables. See Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”.
mysqlaccess
A script that checks the access privileges for a host name, user name, and database combination. See Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”.
mysqlbinlog
A utility for reading statements from a binary log. The log of executed statements contained in the binary log files can be used to help recover from a crash. See Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”.
mysqldumpslow
A utility to read and summarize the contents of a slow query log. See Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”.
mysqlhotcopy
A utility that quickly makes backups of MyISAM tables while the server is running. See Section 4.6.9, “mysqlhotcopy — A Database Backup Program”.
mysql_convert_table_format
A utility that converts tables in a database to use a given storage engine. See Section 4.6.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”.
mysql_find_rows
A utility that reads files containing SQL statements (such as update logs) and extracts statements that match a given regular expression. See Section 4.6.11, “mysql_find_rows — Extract SQL Statements from Files”.
mysql_fix_extensions
A utility that converts the extensions for MyISAM table files to lowercase. This can be useful after transferring the files from a system with case-insensitive file names to a system with case-sensitive file names. See Section 4.6.12, “mysql_fix_extensions — Normalize Table File Name Extensions”.
mysql_setpermission
A utility for interactively setting permissions in the MySQL grant tables. See Section 4.6.13, “mysql_setpermission — Interactively Set Permissions in Grant Tables”.
mysql_waitpid
A utility that kills the process with a given process ID. See Section 4.6.14, “mysql_waitpid — Kill Process and Wait for Its Termination”.
mysql_zap
A utility that kills processes that match a pattern. See Section 4.6.15, “mysql_zap — Kill Processes That Match a Pattern”.
MySQL program-development utilities:
msql2mysql
A shell script that converts mSQL programs to MySQL. It doesn't handle every case, but it gives a good start when converting. See Section 4.7.1, “msql2mysql — Convert mSQL Programs for Use with MySQL”.
mysql_config
A shell script that produces the option values needed when compiling MySQL programs. See Section 4.7.2, “mysql_config — Display Options for Compiling Clients”.
my_print_defaults
A utility that shows which options are present in option groups of option files. See Section 4.7.3, “my_print_defaults — Display Options from Option Files”.
resolve_stack_dump
A utility program that resolves a numeric stack trace dump to symbols. See Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”.
Miscellaneous utilities:
perror
A utility that displays the meaning of system or MySQL error codes. See Section 4.8.1, “perror — Explain Error Codes”.
replace
A utility program that performs string replacement in the input text. See Section 4.8.2, “replace — A String-Replacement Utility”.
resolveip
A utility program that resolves a host name to an IP address or vice versa. See Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”.
Oracle Corporation also provides the MySQL Workbench GUI tool, which is used to administer MySQL servers and databases, to create, execute, and evaluate queries, and to migrate schemas and data from other relational database management systems for use with MySQL. Additional GUI tools include MySQL Notifier for Microsoft Windows MySQL for Excel.
MySQL client programs that communicate with the server using the MySQL client/server library use the following environment variables.
Environment Variable Meaning MYSQL_UNIX_PORT The default Unix socket file; used for connections to localhost MYSQL_TCP_PORT The default port number; used for TCP/IP connections MYSQL_PWD The default password MYSQL_DEBUG Debug trace options when debugging TMPDIR The directory where temporary tables and files are created For a full list of environment variables used by MySQL programs, see Section 2.12, “Environment Variables”.
Mysql configuration file in /etc/my.cnf
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used (fedora >= 15). # If you need to run mysqld under a different user or group, # customize your systemd unit file for mysqld according to the # instructions in http://fedoraproject.org/wiki/Systemd user=mysql # Semisynchronous Replication # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html # uncomment next line on MASTER ;plugin-load=rpl_semi_sync_master=semisync_master.so # uncomment next line on SLAVE ;plugin-load=rpl_semi_sync_slave=semisync_slave.so # Others options for Semisynchronous Replication ;rpl_semi_sync_master_enabled=1 ;rpl_semi_sync_master_timeout=10 ;rpl_semi_sync_slave_enabled=1 # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html ;performance_schema [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
mysql --help
mysql Ver 14.14 Distrib 5.5.36, for Linux (x86_64) using readline 5.1
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?
--auto-rehash Enable automatic rehashing. One doesn't need to use
'rehash' to get table and field completion, but startup
and reconnecting may take a longer time. Disable with
--disable-auto-rehash.
(Defaults to on; use --skip-auto-rehash to disable.)
-A, --no-auto-rehash
No automatic rehashing. One has to use 'rehash' to get
table and field completion. This gives a quicker start of
mysql and disables rehashing on reconnect.
--auto-vertical-output
Automatically switch to vertical output mode if the
result is wider than the terminal width.
-B, --batch Don't use history file. Disable interactive behavior.
(Enables --silent.)
--character-sets-dir=name
Directory for character set files.
--column-type-info Display column type information.
-c, --comments Preserve comments. Send comments to the server. The
default is --skip-comments (discard comments), enable
with --comments.
-C, --compress Use compression in server/client protocol.
-#, --debug[=#] This is a non-debug version. Catch this and exit.
--debug-check Check memory and open file usage at exit.
-T, --debug-info Print some debug info at exit.
-D, --database=name Database to use.
--default-character-set=name
Set the default character set.
--delimiter=name Delimiter to be used.
--enable-cleartext-plugin
Enable/disable the clear text authentication plugin.
-e, --execute=name Execute command and quit. (Disables --force and history
file.)
-E, --vertical Print the output of a query (rows) vertically.
-f, --force Continue even if we get an SQL error.
-G, --named-commands
Enable named commands. Named commands mean this program's
internal commands; see mysql> help . When enabled, the
named commands can be used from any line of the query,
otherwise only from the first line, before an enter.
Disable with --disable-named-commands. This option is
disabled by default.
-i, --ignore-spaces Ignore space after function names.
--init-command=name SQL Command to execute when connecting to MySQL server.
Will automatically be re-executed when reconnecting.
--local-infile Enable/disable LOAD DATA LOCAL INFILE.
-b, --no-beep Turn off beep on error.
-h, --host=name Connect to host.
-H, --html Produce HTML output.
-X, --xml Produce XML output.
--line-numbers Write line numbers for errors.
(Defaults to on; use --skip-line-numbers to disable.)
-L, --skip-line-numbers
Don't write line number for errors.
-n, --unbuffered Flush buffer after each query.
--column-names Write column names in results.
(Defaults to on; use --skip-column-names to disable.)
-N, --skip-column-names
Don't write column names in results.
--sigint-ignore Ignore SIGINT (CTRL-C).
-o, --one-database Ignore statements except those that occur while the
default database is the one named at the command line.
--pager[=name] Pager to use to display results. If you don't supply an
option, the default pager is taken from your ENV variable
PAGER. Valid pagers are less, more, cat [> filename],
etc. See interactive help (\h) also. This option does not
work in batch mode. Disable with --disable-pager. This
option is disabled by default.
-p, --password[=name]
Password to use when connecting to server. If password is
not given it's asked from the tty.
-P, --port=# Port number to use for connection or 0 for default to, in
order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/services, built-in default (3306).
--prompt=name Set the mysql prompt to this value.
--protocol=name The protocol to use for connection (tcp, socket, pipe,
memory).
-q, --quick Don't cache result, print it row by row. This may slow
down the server if the output is suspended. Doesn't use
history file.
-r, --raw Write fields without conversion. Used with --batch.
--reconnect Reconnect if the connection is lost. Disable with
--disable-reconnect. This option is enabled by default.
(Defaults to on; use --skip-reconnect to disable.)
-s, --silent Be more silent. Print results with a tab as separator,
each row on new line.
-S, --socket=name The socket file to use for connection.
--ssl Enable SSL for connection (automatically enabled with
other flags).
--ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
--ssl).
--ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
--ssl-cert=name X509 cert in PEM format (implies --ssl).
--ssl-cipher=name SSL cipher to use (implies --ssl).
--ssl-key=name X509 key in PEM format (implies --ssl).
--ssl-verify-server-cert
Verify server's "Common Name" in its cert against
hostname used when connecting. This option is disabled by
default.
-t, --table Output in table format.
--tee=name Append everything into outfile. See interactive help (\h)
also. Does not work in batch mode. Disable with
--disable-tee. This option is disabled by default.
-u, --user=name User for login if not current user.
-U, --safe-updates Only allow UPDATE and DELETE that uses keys.
-U, --i-am-a-dummy Synonym for option --safe-updates, -U.
-v, --verbose Write more. (-v -v -v gives the table output format).
-V, --version Output version information and exit.
-w, --wait Wait and retry if connection is down.
--connect-timeout=# Number of seconds before connection timeout.
--max-allowed-packet=#
The maximum packet length to send to or receive from
server.
--net-buffer-length=#
The buffer size for TCP/IP and socket communication.
--select-limit=# Automatic limit for SELECT when using --safe-updates.
--max-join-size=# Automatic limit for rows in a join when using
--safe-updates.
--secure-auth Refuse client connecting to server if it uses old
(pre-4.1.1) protocol.
--server-arg=name Send embedded server this as a parameter.
--show-warnings Show warnings after every statement.
--plugin-dir=name Directory for client-side plugins.
--default-auth=name Default authentication client-side plugin to use.
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit.
--no-defaults Don't read default options from any option file.
--defaults-file=# Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash TRUE
auto-vertical-output FALSE
character-sets-dir (No default value)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (No default value)
default-character-set auto
delimiter ;
enable-cleartext-plugin FALSE
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
init-command (No default value)
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 0
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket (No default value)
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
table FALSE
user (No default value)
safe-updates FALSE
i-am-a-dummy FALSE
connect-timeout 0
max-allowed-packet 16777216
net-buffer-length 16384
select-limit 1000
max-join-size 1000000
secure-auth FALSE
show-warnings FALSE
plugin-dir (No default value)
default-auth (No default value)