Developer's Daily | Unix by Example |
main | java | perl | unix | dev directory | web log |
mysqladmin [OPTIONS] command command.... ? A utility for performing administrative operations |
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]] |
You can get a list of the options your version of mysqladmin supports by executing mysqladmin ??help |
?#|??debug=logfile |
Output debug log. Often this is ’d:t:o,filename‘ |
?f|??force |
Don’t ask for confirmation on drop database; with multiple 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 server If 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 values when used with -i extended-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 |
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] |
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 |
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), |
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurmedia.com) |