sudo   apt-get   install   mysql-admin

mysqladmin   -u<user-id>  -p[password]    [options]   command  command....

--help, -?

Display a help message and exit.  

--host=host_name,

 -h host_name

Connect to the MySQL server on the given host.

--user=user_name,

-u user_name

The MySQL user name to use when connecting to the server.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or –p option on the Shell, mysql prompts for one. Specifying a password on the Shell should be considered insecure.  See Section 6.1.2.1, "End-User Guidelines for Password Security". You can use an option file to avoid giving the password on the Shell.

command

Description

비고

create databasename

Create a new database

database 생성

debug

Instruct server to write debug information to log

drop databasename

Delete a database and all its tables

database 삭제

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 in current format

계정 password 변경하기

old-password [new-password]

Change old password to new-password in old format

계정 password 변경하기

ping

Check if mysqld is alive

MySQL 실행 여부 확인

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

MySQL 종료

start-slave

Start slave

stop-slave

Stop slave

status

Gives a short status message from the server

요약 정보 조회

variables

Prints variables available

환경변수 확인

version

Get version info from server

버전 등 상세 정보

sudo   apt-get   install   mysql-client

mysqldump  -u<user-id>   -p[password]   [option]   [database-name]  [table-name]

--help, -?

Display a help message and exit.  

--host=host_name,

 -h host_name

Connect to the MySQL server on the given host.

--user=user_name,

-u user_name

The MySQL user name to use when connecting to the server.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or –p option on the Shell, mysql prompts for one. Specifying a password on the Shell should be considered insecure. See Section 6.1.2.1, "End-User Guidelines for Password Security". You can use an option file to avoid giving the password on the Shell.

--all-databases, -A

Dump all tables in all databases. This is the same as using the --databases option and naming all the databases on the Shell.

--all-tablespaces, -Y

Adds to a table dump all SQL statements needed to create any tablespaces used by an NDBCLUSTER table. This information is not otherwise included in the output from mysqldump. This option is currently relevant only to MySQL Cluster tables.

mysqlimport  -u<user-id>   -p[password]   [option]  <database-name>  <file-name>

--help, -?

Display a help message and exit.  

--host=host_name,

 -h host_name

Connect to the MySQL server on the given host.

--user=user_name,

-u user_name

The MySQL user name to use when connecting to the server.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or –p option on the Shell, mysql prompts for one. Specifying a password on the Shell should be considered insecure. See Section 6.1.2.1, "End-User Guidelines for Password Security". You can use an option file to avoid giving the password on the Shell.

--delete, -D

Empty the table before importing the text file.

--force, -f

Ignore errors. For example, if a table for a text file does not exist, continue processing any remaining files. Without --force, mysqlimport exits if a table does not exist.

--lock-tables, -l

Lock all tables for writing before processing any text files. This ensures that all tables are synchronized on the server.