mysqladmin

mysqladmin

The mysqladmin utility communicates with the MySQL server to perform a variety of administrative operations. You can use mysqladmin to obtain information from or control the operation of the server, set passwords, and create or drop databases.

Usage

 mysqladmin [options] command ...  

Standard Options Supported by mysqladmin

 --character-sets-dir       --password             --socket  --compress                 --pipe                 --user --debug                    --port                 --verbose --help                     --set-variable         --version --host                     --silent 

--silent causes mysqladmin to exit silently if it cannot connect to the server. --verbose was added in MySQL 3.22.30. It causes mysqladmin to print more information for a few commands. --character-sets-dir was added in 3.23.21. As of MySQL 4, mysqladmin also supports the standard SSL options.

Options Specific to mysqladmin

  • --count=n, -c n

    The number of iterations to make when --sleep is given. This option was introduced in MySQL 4.0.3.

  • --force, -f (boolean)

    This option has two effects. First, it causes mysqladmin not to ask for confirmation of the drop db_name command. Second, when multiple commands are specified on the command line, mysqladmin attempts to execute each command even if errors occur. Normally, mysqladmin will exit after the first error.

  • --relative-r (boolean)

    Show the difference between the current and previous values when used with --sleep. Currently, this option works only with the extended-status command.

  • --sleep=n, -i n

    Execute the commands named on the command line repeatedly with a delay of n seconds between each repetition.

  • --timeout=n, -t n

    Wait n seconds before timing out when attempting to connect to the server. This option was introduced in MySQL 3.22.1 and removed in 3.23.29 when the connect_timeout variable was introduced.

  • --vertical, -E (boolean)

    This option is like --relative but displays output vertically. It was introduced in MySQL 3.23.14.

  • --wait[=n], -w[n]

    The number of times to wait and retry if a connection to the server cannot be established. The default value of n is 1 if no value is given. If n is specified after -w, there must be no intervening space or the value will not be interpreted correctly.

Variables for mysqladmin

The following mysqladmin variables can be set using the instructions in the "Setting Program Variables" section earlier in this appendix.

  • connect_timeout

    The number of seconds to wait before timing out when attempting to connect to the server. This variable was introduced in MySQL 3.23.29 when the --timeout option was removed.

  • shutdown_timeout

    For shutdown commands, the number of seconds to wait for a successful shutdown. This variable was introduced in MySQL 3.23.34.

mysqladmin Commands

Following any options on the command line, you can specify one or more of the following commands. Each command name can be shortened to a prefix, as long as the prefix is unambiguous. For example, processlist can be shortened to process or proc, but not to p.

Several of these commands have an equivalent SQL statement, as noted in the descriptions. For more information about the meaning of the SQL statements, see Appendix D, "SQL Syntax Reference."

  • create db_name

    Create a new database with the given name. This command is like the CREATE DATABASE db_name statement.

  • drop db_name

    Delete the database with the given name and any tables that may be in the database. Be careful with this command; you can't get the database back. mysqladmin asks for confirmation of this command unless the --force option was given. This command is like the DROP DATABASE db_name statement.

  • debug

    Instruct the server to dump debugging information.

  • extended-status

    Display the names and values of the server's status variables. This command is like the SHOW STATUS statement. It was introduced in MySQL 3.22.10.

  • flush-hosts

    Flush the host cache. This command is like the FLUSH HOSTS statement.

  • flush-logs

    Flush (close and reopen) the log files. This command is like the FLUSH LOGS statement.

  • flush-privileges

    Reload the grant tables. This command is like the FLUSH PRIVILEGES statement. It was introduced in MySQL 3.22.12.

  • flush-status

    Clear the status variables. (This resets several counters to zero.) This command is like the FLUSH STATUS statement.

  • flush-tables

    Flush the table cache. This command is like the FLUSH TABLES statement.

  • flush-threads

    Flush the thread cache.

  • kill id, id, …

    Kill the server threads specified by the given identifier numbers. If you specify multiple numbers, the ID list should contain no spaces so that it will not be confused for another command following the kill command. To find out what threads are currently running, use mysqladmin processlist., This command is like issuing a KILL statement for each thread ID.

  • password new_password

    Change the password for account that you use when invoking mysqladmin (Being able to connect to the server using this account serves as verification that you know the current password.) The password will be set to new_password. This command is like the SET PASSWORD statement.

  • ping

    Check whether the MySQL server is running.

  • processlist

    Display a list of the currently executing server threads. This command is like the SHOW PROCESSLIST statement. With the --verbose option, this command is like SHOW FULL PROCESSLIST.

  • refresh

    This command flushes the table cache and the grant tables and closes and reopens the log files. If the server is a replication master server, the command tells it to delete the binary update logs listed in the binary log index file and to truncate the index. If the server is a slave server, the command tells it to forget its position in the master logs.

  • reload

    Reload the grant tables. This command is like the FLUSH PRIVILEGES statement.

  • shutdown

    Shut down the server.

  • start-slave

    Start a replication slave server. This command is like the SLAVE START statement. It was introduced in MySQL 3.23.16.

  • status

    Display a short status message from the server.

  • stop-slave

    Stop a replication slave server. This command is like the SLAVE STOP statement. It was introduced in MySQL 3.23.16.

  • variables

    Display the names and values of the server's variables. This command is like the SHOW VARIABLES statement. As of MySQL 4.0.3, which supports the notion of both global and session variables, this command is like SHOW GLOBAL VARIABLES. (There is no support for SHOW SESSION VARIABLES because that wouldn't make any sense.)

  • version

    Retrieve and display the server version information string. This is the same information that is returned by the VERSION() function (see Appendix C, "Operator and Function Reference").



MySQL
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
Year: 2003
Pages: 188

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net