MAN page from Trustix mysql-client-3.23.58-3tr.i586.rpm
mysqladmin
Section: MySQL database (1)
Updated: 19 December 2000
Index NAME
mysqladmin [OPTIONS] command command.... - A utility for performing administrative operations
OPTION SYNOPSIS
mysqladmin[
-#|
--debug=logfile][
-f|
--force][
-?|
--help]
[--character-sets-dir=
directory][
-C|
--compress][
-h|
--host=[#]][
-p[pwd]][
--password=[pwd]][
-P|
--port=pnum][
-i|
--sleep=sec][
-E|
--vertical][
-s|
--silent][
-S|
--socket=#][
-r|
--relative][
-t|
--timeout=#][
-u|
--user=uname][
-v|
--verbose][
-V|
--version][
-w|
--wait[=retries]]
OPTION DESCRIPTION
You can get a list of the options your version of
mysqladminsupports by executing
mysqladmin --help OPTIONS
- -#|--debug=logfile
- Output debug log. Often this is 'd:t:o,filename`
- -f|--force
- Don't ask for confirmation on drop database; withmultiple commands, continue even if an error occurs
- -?|--help
Display help and exit- --character-sets-dir=directory
- Set the character set directory
- -C|--compress
- Use compression in server/client protocol
- -h|--host=hostname
- Connect to host
- -p|--password[=pwd]
- Password to use when connecting to serverIf password is not given it's asked from the tty
- -P|--port=pnum
- Port number to use for connection
- -i|--sleep=sec
- Execute commands again and again with a sleep between
- -r|--relative
- Show difference between current and previous valueswhen used with -iextended-status
- -E|--vertical
- Print output vertically. Is similar to --relative,but prints output vertically.
- -s|--silent
- Silently exit if one can't connect to server
- -S|--socket=file
- Socket file to use for connection
- -t|--timeout=sec
- Timeout for connection to the mysqld server
- -u|--user=uname
- User for login if not current user
- -v|--verbose
- Write more information
- -V|--version
- Output version information and exit
- -w|--wait
Wait and retry if connection is down
COMMAND SYNOPSIS
MySQLADMIN[
create databasename ][
drop databasename][
extended-status][
flush-hosts][
flush-logs][
flush-tables][
flush-privileges][
kill id,id,... ][
password new-password ][
ping][
processlist][
reload][
refresh][
shutdown][
slave-start][
slave-stop][
status][
variables][
version]
COMMANDS
Where command is a one or more of: (Commands may be shortened)
- create databasename
- Create a new database
- drop databasename
- Delete a database and all its tables
- extended-status
- Gives an extended status message from the server
- flush-hosts
- Flush all cached hosts
- flush-logs
- Flush all logs
- flush-status
- Clear status variables
- flush-tables
- Flush all tables
- flush-threads
- Flush the thread cache
- flush-privileges
- Reload grant tables (same as reload)
- kill id,id,...
- Kill mysql threads
- password new-password
- Change old password to new-password
- ping
- Check if mysqld is alive
- processlist
- Show list of active threads in server
- reload
- Reload grant tables
- refresh
- Flush all tables and close and open logfiles
- shutdown
- Take server down
- status
- Gives a short status message from the server
- variables
- Prints variables available
- version
- Get version info from server
SEE ALSO
isamchk (1),isamlog (1),mysqlaccess (1),mysqladmin (1),mysqlbug (1),mysqld (1),mysqldump (1),mysqlshow (1),msql2mysql (1),perror (1),replace (1),safe_mysqld (1),which1 (1),zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29aMichael (Monty) Widenius (montyAATTtcx.se),TCX Datakonsult AB (
http://www.tcx.se).This software comes with no warranty.Manual page by L. (Kill-9) Pedersen (kill-9AATTkill-9.dk), Mercurmedia Data Model Architect /system developer (
http://www.mercurmedia.com)
Index
- NAME
- OPTION SYNOPSIS
- OPTION DESCRIPTION
- OPTIONS
- COMMAND SYNOPSIS
- COMMANDS
- SEE ALSO
- AUTHOR
This document was created byman2html,using the manual pages.
