Íîâîñòè
Äîêóìåíòàöèÿ
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-repair

Description

--base64-output

Description

--base64-output[=value]

Description

--binlog-direct-non-transactional-updates

Section 16.1.2.4, “Binary Log Options and Variables”

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

Section 16.1.2.4, “Binary Log Options and Variables”

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

Section 5.1.2, “Server Command Options”

--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

--clear-only

Description

--collation-server=collation_name

Section 5.1.2, “Server Command Options”

--columns=column_list

Description

--commit

Description

--compact

Description

--compatible

Description

--compatible=name

Description

--compatible=oracle

Description

--complete-insert

Description

--config-file=file_name

Description
Description

--core-file-size=size

Description

--count=N

Description

--create-options

Description

--daemon

Description

--database

Description

--date=YYMMDD

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

--delete

Description

--delete-master-logs

Description

--dirname

Description

--disable-keys

Description

--disable-log-bin

Description

--dryrun

Description

--dump-date

Description

--dump-slave

Description

--dump-slave[=value]

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

--hexdump

Description

--ignore

Description

--ignore-lines=N

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

--join=big_tbl_name

Description

--keepold

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

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

Section 5.1.2, “Server Command Options”

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

Section 16.1.2.4, “Binary Log Options and Variables”

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

Section 16.1.2.4, “Binary Log Options and Variables”

--log-bin=base_name.extension

Section 5.2.3, “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.2, “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.8.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

Description

--nowait-nodes=3

Description

--nowait-nodes=3,5

Description

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

Description

--numeric-dump-file=file_name

Description

--offset=N

Description

--old_server

Description

--only-debug

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

--prefix=prefix_str

Description

--preview

Description

--printerror=1

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.2.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

--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.2.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.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--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

Description

--suffix=str

Description

--superuser=user_name

Description

--symbols-file=file_name

Description

--tab=path

Description

--tbl-status

Description

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

Section 5.1.2, “Server Command Options”

--tcp-ip

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=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-named-thread-libs="-lpthread -lmach -lexc -lc"

Section 2.19.5.6, “Alpha-DEC-OSF/1 Notes”

--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 20.8.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

-d YYMMDD

Description

-e file_name

Description

-g pattern

Description

-g suffix

Description

-i delay

Description

-j big_tbl_name

Description

-mcpu=v8 -Wa,-xarch=v8plusa

Section 2.19.3, “Solaris Notes”

-n file_name

Description

-o offset

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.5, “Defining MySQL Cluster Data Nodes”

default-storage-engine

Chapter 13, Storage Engines

extended-status

Description

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.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.2, “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.17, “SHOW GRANTS Syntax”
Section 20.8.3.3, “mysql_change_user()
Section 20.8.3.5, “mysql_close()
Section 20.8.3.14, “mysql_errno()
Section 20.8.3.15, “mysql_error()
Section 20.8.3.33, “mysql_get_ssl_cipher()
Section 20.8.3.36, “mysql_init()
Section 20.8.3.53, “mysql_real_escape_string()
Section 20.8.3.60, “mysql_select_db()
Section 20.8.3.67, “mysql_ssl_set()
Section 20.8.7.10, “mysql_stmt_execute()
Section 20.8.7.11, “mysql_stmt_fetch()
Section 20.8.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 20.8.14, “C API Prepared Statement Handling of Date and Time Values”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 9.1.4, “Connection Character Sets and Collations”
Chapter 20, Connectors and APIs
Section 13.2.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.18.5, “Copying MySQL Databases to Another Machine”
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.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
Description
Description
Description
Description
Section 2.18.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 13.7.2, “How to Use FEDERATED Tables”
Section 2.15, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.10, “Installing MySQL from RPM Packages on Linux”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.12, “Installing MySQL on Solaris”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 1.5, “What Is New in MySQL 5.0”
Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”
Section 17.5.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 20.9, “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.17.2.1, “Problems Running mysql_install_db
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.7, “Replication and FLUSH
Section 16.3.1.26, “Replication and User Privileges”
Section 16.3.1.15, “Replication of the System mysql Database”
Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
Section 13.2.14, “Restrictions on InnoDB Tables”
Section D.6, “Restrictions on Character Sets”
Section D.1, “Restrictions on Stored Routines and Triggers”
Section 2.19.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.17.3, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.1.8, “Server-Side Help”
Section 2.16.1, “Source Installation Overview”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
Section 2.17.2.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 2.9.13, “Troubleshooting a MySQL Installation Under Windows”
Section 2.17.2, “Unix Post-Installation Procedures”
Section 2.18.1, “Upgrading MySQL”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 13.2.2.2, “Using Raw Devices for the Shared Tablespace”
Section 5.5.7.2, “Using SSL Connections”
Section 21.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 18.2, “Using Stored Routines (Procedures and Functions)”
Section 2.17.1, “Windows Post-Installation Procedures”

mysql_tableinfo

Description

mysqlaccess

Description

mysqldump

Description

mysqldumpslow

Description

mysqlhotcopy

Description

nonguarded

Description

password

Description

processlist

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 20.8.3.49, “mysql_options()
Section 20.8.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.2.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.18.5, “Copying MySQL Databases to Another Machine”
Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
Description
Section 11.10.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.17.3, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.4.3, “Specifying Account Names”
Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
Section 2.17.2, “Unix Post-Installation Procedures”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”

variables

Description



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