MYSQL常用操作命令

root用户普通连接MYSQL

mysql -hlocalhost -uroot -p

查看基本信息

mysql> \s
--------------
mysql  Ver 14.14 Distrib 5.7.40, for Linux (x86_64) using  EditLine wrapper

Connection id:      962
Current database:   
Current user:       root@localhost
SSL:            Not in use
Current pager:      stdout
Using outfile:      ''
Using delimiter:    ;
Server version:     5.7.40-log Source distribution
Protocol version:   10
Connection:     Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:        /tmp/mysql.sock
Uptime:         1 day 14 hours 49 min 14 sec

Threads: 11  Questions: 7660  Slow queries: 0  Opens: 175  Flush tables: 1  Open tables: 83  Queries per second avg: 0.054
--------------

导出指定数据库

如果命令不存在，cd到mysql的bin目录下

mysql -u root -p database_name < /home/bak/dump.txt

导出指定数据库+指定表

如果命令不存在，cd到mysql的bin目录下

mysqldump -u root -p database_name table_name > /home/bak/dump.txt
#或者
./bin/mysqldump -u root -S mysql.sock -p database_name table_name > /home/dump.sql

导入SQL

mysql> source /home/abc/abc.sql