«   2018/06   »
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
Archives
Today
343
Total
1,112,203
안정적인 DNS서비스 DNSEver
관리 메뉴

Blue Breeze

mysql cmd query 본문

DB&NoSQL/MySQL

mysql cmd query

푸른바람 C/H 2017.04.20 08:30

mysql -u user -p PASSWORD -e 'Execute sql query' database_name
mysql -uUESRNAME -pPASSWORD -h MYSQLSERVERNAME --port=3306 -e 'show tables;' database_name

+-----------------------------+
| Tables_in_database_name     |
+-----------------------------+
| access_keys                 |
+-----------------------------+


mysqldump -uUESRNAME -pPASSWORD DATABASE_NAME TABLE_NAME -C --where='created < "2017-01-01"' > DATABASE.TABLE.20170101.sql
mysqldump -uUESRNAME -pPASSWORD DATABASE_NAME TABLE_NAME -C --where='created < "2017-01-01"' | gzip > DATABASE.TABLE.20170101.sql.gz


'DB&NoSQL > MySQL' 카테고리의 다른 글

Access denied; you need (at least one of) the SUPER privilege(s) for this operation  (0) 2018.04.02
Centos7 Mariadb datadir change  (0) 2018.03.07
mysql cmd query  (0) 2017.04.20
centos7 mysql5.7  (0) 2017.02.24
mysqladmin 퍼포먼스 정보 확인  (0) 2017.02.03
Shell 에서 MySQL 용량확인  (0) 2017.01.31
0 Comments
댓글쓰기 폼