MySQL Client Programs

MySQL Client Programs

Shawn Yan Lv.6
  2018-04-23 16:17:01 2018-04-23 16:17:01 Created   2018-04-23 16:17:01 2018-04-23 16:17:01 Updated      49 Words  1 Mins  

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.
推荐阅读
温故知新 | mydumper & dumpling 知识点汇总 温故知新 | mydumper & dumpling 知识点汇总 My New Post My New Post MySQL 日志 MySQL 日志
推荐阅读
温故知新 | mydumper & dumpling 知识点汇总 温故知新 | mydumper & dumpling 知识点汇总 My New Post My New Post
 Comments
On this page
  1. mysqlshow
  2. mysqldump
  3. Reference