Oracle ACE

MySQL

MySQL Client Programs

2018-04-23 49 words 1 min read views

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

mysql client mysqldump
Copyright Notice

Author: Shawn Yan

Link: https://shawnyan.cn/2018/mysql/mysql-client/index.html

License: All articles on this site are original unless otherwise stated. Please indicate the source when reprinting!