MySQL Client Programs

MySQL Client Programs

Shawn Yan Lv.6

mysqlshow

  • Usage
1
2
3
4
5
6
7
8
# status
mysqlshow -uroot test -i

# count
mysqlshow -uroot test --count

# key
mysqlshow -uroot test author -k

mysqldump

1
2
3
4
5
# table
mysqldump -uroot -d -B testdb > testdb_table_bk_`date +%Y%m%d_%H%M%S`.sql

# data
mysqldump -uroot -t -B testdb > testdb_data_bk_`date +%Y%m%d_%H%M%S`.sql

Reference

  • Title: MySQL Client Programs
  • Author: Shawn Yan
  • Created at: 2018-04-23 16:17:01
  • Updated at: 2018-04-23 16:17:01
  • Link: https://shawnyan.cn/2018/mysql/mysql-client/
  • License: This work is licensed under CC BY-NC-SA 4.0.
 Comments