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
if (hexo-config('comment.enable') == true && hexo-config('comment.system') != "") { if (hexo-config('comment.system') == "waline") { @require "./waline.styl" } else if (hexo-config('comment.system') == "gitalk") { @require "./gitalk.styl" } else if (hexo-config('comment.system') == "twikoo") { @require "./twikoo.styl" } } .comments-container display inline-block margin-top $spacing-unit width 100% #comment-anchor width 100% height 10px .comment-area-title width 100% margin 10px 0 font-size 1.38rem color var(--default-text-color) font-family 'Consolas', '宋体', sans-serif font-weight bold i color var(--default-text-color) +redefine-tablet() margin 5px 0 font-size 1.2rem
On this page
  1. mysqlshow
  2. mysqldump
  3. Reference