Íîâîñòè
Äîêóìåíòàöèÿ
Download
Webboard
Ïîèñê
FAQ/×àÂî
Îáðàòíàÿ ñâÿçü




Option Index

-#debug_options

Description

--Information

Description

--add-drop-database

Description

--add-drop-table

Description

--add-locks

Description

--addtodest

Description

--all-in-1

Description

--allow-keywords

Description

--allowold

Description

--apply-slave-statements

Description

--auto-generate-sql

Description

--auto-generate-sql-add-autoincrement

Description

--auto-generate-sql-execute-number=N

Description

--auto-generate-sql-guid-primary

Description

--auto-generate-sql-load-type=type

Description

--auto-generate-sql-secondary-indexes=N

Description

--auto-generate-sql-select-columns=str

Description

--auto-generate-sql-unique-query-number=N

Description

--auto-generate-sql-unique-write-number=N

Description

--auto-generate-sql-write-number

Description

--auto-generate-sql-write-number=N

Description

--auto-repair

Description

--autoclose

Description

--base64-output

Description

--base64-output[=value]

Description

--binlog-direct-non-transactional-updates

Section 16.1.3.4, “Binary Log Options and Variables”

--binlog-direct-non-transactional-updates[={0|1}]

Section 16.1.3.4, “Binary Log Options and Variables”

--binlog-format={ROW|STATEMENT|MIXED}

Section 5.1.2, “Server Command Options”

--burnin

Description

--cflags

Description

--character-set-filesystem=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server=charset_name

Section 5.1.2, “Server Command Options”

--charset=path

Description

--check-upgrade

Description
Description

--checkpoint

Description

--checkpoint=db_name.tbl_name

Description

--chroot

Description

--collation-server=collation_name

Section 5.1.2, “Server Command Options”

--columns=column_list

Description

--commit

Description

--commit=N

Description

--compact

Description

--compatible

Description

--compatible=name

Description

--compatible=oracle

Description

--complete-insert

Description

--concurrency=N

Description

--config-file=file_name

Description
Description

--core-file-size=size

Description

--count=N

Description

--create

Description

--create-options

Description

--create-schema=value

Description

--create=value

Description

--csv[=file_name]

Description

--daemon

Description

--database

Description

--db=db_name

Description

--debug=N

Description

--default-character-set=system_character_set

Section 9.2, “The Character Set Used for Data and Sorting”

--default-collation=collation_name

Section 5.1.2, “Server Command Options”

--defaults-group-suffix=suffix

Description

--delay-key-write-for-all-tables

Section 5.1.2, “Server Command Options”

--delay-key-write[={OFF|ON|ALL}]

Section 5.1.2, “Server Command Options”

--delayed-insert

Description

--delayed-start=N

Description

--delete

Description

--delete-master-logs

Description

--delimiter

Description

--detach=N

Description

--disable-keys

Description

--disable-log-bin

Description

--dryrun

Description

--dump-date

Description

--dump-slave

Description

--dump-slave[=value]

Description

--engine=engine_name

Description

--events

Description

--example

Description

--exe-suffix=suffix

Description

--extended

Description

--extended-insert

Description

--extra-file=file_name

Description

--fields-enclosed-by=...

Description
Description

--fields-escaped-by=...

Description
Description

--fields-optionally-enclosed-by=...

Description
Description

--fields-terminated-by=...

Description
Description

--fields-xxx

Description

--first-slave

Description

--fix-db-names

Description

--fix-table-names

Description

--flush-logs

Description

--flush-privileges

Description

--flushlog

Description

--force-read

Description

--header_file=file_name

Description

--hex-blob

Description

--ignore

Description

--ignore-lines=N

Description

--ignore-sql-errors

Description

--ignore-table=db_name.tbl_name

Description

--in_file=file_name

Description

--include

Description

--include-master-host-port

Description

--initial-start

Description

--insert-ignore

Description

--iterations=N

Description

--join=big_tbl_name

Description

--keepold

Description

--label=str

Description

--language=lang_name, -L lang_name

Section 5.1.2, “Server Command Options”

--ldata=path

Description

--ledir=path

Description

--length

Description

--libmysqld-libs

Description

--libs_r

Description

--lines-terminated-by

Description

--lines-terminated-by="\r\n"

Description

--lines-terminated-by=...

Description
Description

--local-load

Description

--local-load=path

Description

--lock-all-tables

Description

--lock-directory

Description

--lock-directory=path

Description

--log-backup-output[=value,...]

Section 5.1.2, “Server Command Options”

--log-bin-trust-function-creators[={0|1}]

Section 16.1.3.4, “Binary Log Options and Variables”

--log-bin-trust-routine-creators[={0|1}]

Section 16.1.3.4, “Binary Log Options and Variables”

--log-bin=base_name.extension

Section 5.2.4, “The Binary Log”

--low-priority

Description

--malloc-lib

Description

--malloc-lib=

Description

--malloc-lib=/path/to/some/library

Description

--malloc-lib=[lib_name]

Description

--malloc-lib=tcmalloc

Description

--master-data[=value]

Description

--max_connect_errors=999999999

Section 12.5.6.3, “FLUSH Syntax”

--method=command

Description

--min-examined-row-limit=number

Section 5.1.2, “Server Command Options”

--myisam-recover[=option[,option]...]]

Section 5.1.2, “Server Command Options”

--mysqladmin=prog_name

Description

--mysqld-version=debug

Description

--mysqld-version=max

Description

--mysqld-version=suffix

Description

--mysqld=mysqld_safe

Description

--mysqld=prog_name

Description
Description

--name_file=file_name

Description

--ndbcluster --ndb-connectstring=management_host

Section 17.5.9.2, “MySQL Cluster and MySQL Privileges”

--nice=priority

Description

--no-autocommit

Description

--no-create-db

Description

--no-create-info

Description

--no-data

Description

--no-debug

Description

--no-embedded

Description

--no-log

Description

--no-set-names

Description

--nodaemon

Description

--noindices

Description

--nostart

Description

--nowait-nodes=3

Description

--nowait-nodes=3,5

Description

--nowait-nodes=node_id_1[, node_id_2[, ...]]

Description

--number-blob-cols=str

Description

--number-char-cols=N

Description

--number-int-cols=N

Description

--number-of-queries=N

Description

--numeric-dump-file=file_name

Description

--offset=N

Description

--old_server

Description

--only-debug

Description

--only-print

Description

--optimize

Description

--order-by-primary

Description

--out_dir=path

Description

--out_file=file_name

Description

--packlength=len

Description

--plugin-innodb_file_per_table

Section 5.1.2, “Server Command Options”

--plugindir

Description

--position

Description

--position=N

Description

--post-query=value

Description

--post-system=str

Description

--pre-query=value

Description

--pre-system=str

Description

--preserve-schema

Description

--preview

Description

--query=value

Description

--read-from-remote-server

Description

--record_log_pos

Description

--record_log_pos=db_name.tbl_name

Description

--regexp=expr

Description

--regexp=pattern

Description

--relative

Description

--relnotes

Description

--repair

Description

--replicate-wild-ignore-table=db_name.tbl_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--resetmaster

Description

--resetslave

Description

--result-file=file_name

Description

--result-file=name

Description

--rhost=host_name

Description

--rollback

Description

--rows=N

Description

--server-id=id

Description

--service-startup-timeout=file_name

Description

--set-charset

Description

--set-charset=charset_name

Description

--set-random-seed=value

Description

--short-form

Description

--show-table-type

Description

--skip-add-drop-table

Description

--skip-add-locks

Description

--skip-base64-output

Description

--skip-comments

Description

--skip-compact

Description

--skip-disable-keys

Description

--skip-dump-date

Description

--skip-extended-insert

Description

--skip-kill-mysqld

Description

--skip-lock-tables

Description

--skip-mutex-deadlock-detector

Section 5.1.2, “Server Command Options”

--skip-plugin-innodb_file_per_table

Section 5.1.2, “Server Command Options”

--skip-quick

Description

--skip-set-charset

Description

--skip-tz-utc

Description

--skip-use-db

Description

--skip-write-binlog

Description
Description

--skip-xxx

Description

--slave-skip-errors=[err_code1,err_code2,...|all]

Section 16.1.3.3, “Replication Slave Options and Variables”

--sleep=delay

Description

--spassword

Description

--spassword[=password]

Description

--sql-mode=NO_UNSIGNED_SUBTRACTION

Section 11.9, “Cast Functions and Operators”

--sql-mode=value[,value[,value...]]

Section 5.1.2, “Server Command Options”

--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"

Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

--srcdir=path

Description

--start-datetime=datetime

Description

--start-position=N

Description

--start_row=N

Description

--statefile=file_name

Description

--status

Description

--stop-datetime=datetime

Description

--stop-position=N

Description

--suffix=str

Description

--superuser=user_name

Description

--symbols-file=file_name

Description

--tab=path

Description

--tc-heuristic-recover={COMMIT|ROLLBACK}

Section 5.1.2, “Server Command Options”

--tcp-ip

Description

--timer-length=N

Description

--timezone=timezone

Description

--to-last-log

Description

--triggers

Description

--type=engine_name

Description

--tz-utc

Description

--upgrade-system-tables

Description

--use-frm

Description

--use-manager

Description

--use-mysqld_safe

Description

--use-threads

Description

--use-threads=N

Description

--wait[=count]

Description

--where='where_condition'

Description

--windows

Description

--with-extra-charsets=list-of-charsets | complex | all | none

Section 9.2, “The Character Set Used for Data and Sorting”

--with-server-suffix=-max

The mysqld-max Extended MySQL Server

-F file_name

Description

-H file_name

Description

-H host_name

Description

-L/usr/local/mysql/lib -lmysqlclient -lz

Section 21.9.16, “Building Client Programs”

-N file_name

Description

-O file_name

Description

-P[password]

Description

-R record_pos_file record_pos

Description

-U user_name

Description

-c column_list

Description

-c file_name

Description

-e engine_name

Description

-e file_name

Description

-g pattern

Description

-g suffix

Description

-i delay

Description

-j big_tbl_name

Description

-n file_name

Description

-o offset

Description

-ppassword

Description

-q value

Description

-r file_name

Description

-s file_name

Description

-s sort_type

Description

-w 'where_condition'

Description

-w write_file

Description

-w[count]

Description

TimeBetweenInactiveTransactionAbortCheck

Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

extended-status

Description

ibmdb2i_compat_opt_time_as_duration

Section 13.7.2, “Configuration Options”

ibmdb2i_compat_opt_year_as_int

Section 13.7.2, “Configuration Options”

ibmdb2i_create_time_columns_as_tod

Section 13.7.2, “Configuration Options”

ibmdb2i_propagate_default_col_val

Section 13.7.2, “Configuration Options”

ibmdb2i_propagate_default_col_vals

Section 13.7.2, “Configuration Options”

mysql

Section 4.5.1.1, “mysql Options”
Section 4.5.1.3, “mysql Server-Side Help”
Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 12.1.16, “CREATE SERVER Syntax”
Section 12.5.1.1, “CREATE USER Syntax”
Section B.5.2.4, “Client does not support authentication protocol
Section 12.5.3.2, “DROP FUNCTION Syntax”
Section 12.5.1.2, “DROP USER Syntax”
Section 12.5.6.3, “FLUSH Syntax”
Section 12.5.1.3, “GRANT Syntax”
Section 12.3.3, “HELP Syntax”
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section B.5.2.9, “MySQL server has gone away
Section 12.5.1.4, “RENAME USER Syntax”
Section 12.5.1.5, “REVOKE Syntax”
Section 12.5.1.6, “SET PASSWORD Syntax”
Section 12.5.5.22, “SHOW GRANTS Syntax”
Section 21.9.3.3, “mysql_change_user()
Section 21.9.3.5, “mysql_close()
Section 21.9.3.14, “mysql_errno()
Section 21.9.3.15, “mysql_error()
Section 21.9.3.33, “mysql_get_ssl_cipher()
Section 21.9.3.36, “mysql_init()
Section 21.9.3.53, “mysql_real_escape_string()
Section 21.9.3.60, “mysql_select_db()
Section 21.9.3.67, “mysql_ssl_set()
Section 21.9.7.10, “mysql_stmt_execute()
Section 21.9.7.11, “mysql_stmt_fetch()
Section 21.9.7.25, “mysql_stmt_send_long_data()
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 12.5.1, “Account Management Statements”
Section 5.5.2, “Adding User Accounts”
Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 6.3.1, “Backup Policy”
Section 21.9.14, “C API Prepared Statement Handling of Date and Time Values”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 22.2.1, “Characteristics of the Plugin Interface”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 9.1.4, “Connection Character Sets and Collations”
Chapter 21, Connectors and APIs
Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.4.5, “Copying MySQL Databases to Another Machine”
Section 13.11.2.1, “Creating a FEDERATED Table Using CONNECTION
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 8.2, “Schema Object Names”
Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Description
Description
Description
Description
Section 2.4.2, “Downgrading MySQL”
Section 7.5.9, “Enabling Large Page Support”
Section 5.3.1, “General Security Guidelines”
Section 7.5.5.1, “How the Query Cache Operates”
Section 16.1.1, “How to Set Up Replication”
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
Section 2.7, “Installing MySQL on Mac OS X”
Section 2.8, “Installing MySQL on Solaris”
Section 5.5.4, “Limiting Account Resources”
Section 5.2.4.4, “Logging Format for Changes to mysql Database Tables”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 1.5, “What Is New in MySQL 5.1”
Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
Section 17.5.9.2, “MySQL Cluster and MySQL Privileges”
Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
Section 2.7.5, “MySQL Installation on Mac OS X Notes”
Section 21.10, “MySQL PHP API”
Section 9.7, “MySQL Server Time Zone Support”
Section 12.4.5.3, “Other Table-Locking Notes”
Section 4.1, “Overview of MySQL Programs”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.13.1.1, “Problems Running mysql_install_db
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and FLUSH
Section 16.3.1.19, “Replication of the System mysql Database”
Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
Section 13.6.14, “Restrictions on InnoDB Tables”
Section D.6, “Restrictions on Character Sets”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 2.13.2, “Securing the Initial MySQL Accounts”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.9, “Server-Side Help”
Section 2.3.1, “Source Installation Overview”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
Section 12.4.3, “Statements That Cause an Implicit Commit”
Section 9.7.1, “Staying Current with Time Zone Changes”
Section 5.4, “The MySQL Access Privilege System”
Section 22.2, “The MySQL Plugin Interface”
Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
Section 2.13.1, “Unix Post-Installation Procedures”
Section 2.4.1, “Upgrading MySQL”
Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”
Section 5.5.7.2, “Using SSL Connections”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 19.2, “Using Stored Routines (Procedures and Functions)”
Section 2.5.8, “Windows Post-Installation Procedures”

mysqlaccess

Description

mysqldump

Description

mysqldumpslow

Description

mysqlhotcopy

Description

mysqlslap

Description

nonguarded

Description

password

Description

processlist

Description

shutdown

Description

shutdown_timeout

Description

start-slave

Description

stop-slave

Description

user

Section 12.5.1.2, “DROP USER Syntax”
Section B.5.2.15, “Ignoring user
Section 21.9.3.49, “mysql_options()
Section 21.9.3.52, “mysql_real_connect()
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.9, “Auditing MySQL Account Activity”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.4.5, “Copying MySQL Databases to Another Machine”
Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
Description
Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.6, “Restrictions on Character Sets”
Section 2.13.2, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.4.3, “Specifying Account Names”
Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
Section 2.13.1, “Unix Post-Installation Procedures”
Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”
Section 11.10, “XML Functions”

variables

Description



ÐÅÊËÀÌÀ ÍÀ ÑÀÉÒÅ
  Ñîçäàíèå ñàéòîâ | |