Skip to main content

Mysql show current selected DB, Dump from host with condition

SELECT DATABASE() FROM DUAL;

or

SELECT DATABASE();

http://stackoverflow.com/questions/19376104/how-to-clear-screen-in-mysql

Clear:
Ctrl + L
or on OSX Command + K ?

Update 1: 27/07/2016:

Dump bình thường
mysqldump -u root -p -h 192.168.x.xxx db_name tbl_name  > note_proj_17.sql

Dump với điều kiện WHERE:
mysqldump -u root -p -h 192.168.x.xxx db_name  tbl_name --where="items_id like '%017'" > note_proj_17.sql

Dump sql với INSERT tách ra:
mysqldump -u root -p -h 192.168.x.xxx db_name tbl_name --extended-insert=FALSE   --where="items_id like '%017'" > note_proj_17.sql


Lưu ý thay user mysql root bằng user bạn muốn login để dump. ip 192 thay bằng IP host bạn cần truy cập.  Điều kiện WHERE để lọc bớt KQ dump cũng tùy y/c logic bạn cần...

Ngoài ra bạn có thể dump từng cột dữ liệu mà bạn cần chứ ko nhất thiết dump cả bảng. Mình có note ở đâu đó sẽ update vô đây sau.

Comments

Popular posts from this blog

Rand mm 10

https://stackoverflow.com/questions/2447791/define-vs-const Oh const vs define, many time I got unexpected interview question. As this one, I do not know much or try to study this. My work flow, and I believe of many programmer is that search topic only when we have task or job to tackle. We ignore many 'basic', 'fundamental' documents, RTFM is boring. So I think it is a trade off between the two way of study language. And I think there are a bridge or balanced way to extract both advantage of two method. There are some huge issue with programmer like me that prevent we master some technique that take only little time if doing properly. For example, some Red Hat certificate program, lesson, course that I have learned during Collage gave our exceptional useful when it cover almost all topic while working with Linux. I remember it called something like RHEL (RedHat Enterprise Linux) Certificate... I think there are many tons of documents, guide n books about Linux bu

Martin Fowler - Software Architecture - Making Architecture matter

  https://martinfowler.com/architecture/ One can appreciate the point of this presentation when one's sense of code smell is trained, functional and utilized. Those controlling the budget as well as developer leads should understand the design stamina hypothesis, so that the appropriate focus and priority is given to internal quality - otherwise pay a high price soon. Andrew Farrell 8 months ago I love that he was able to give an important lesson on the “How?” of software architecture at the very end: delegate decisions to those with the time to focus on them. Very nice and straight-forward talk about the value of software architecture For me, architecture is the distribution of complexity in a system. And also, how subsystems communicate with each other. A battle between craftmanship and the economics and economics always win... https://hackernoon.com/applying-clean-architecture-on-web-application-with-modular-pattern-7b11f1b89011 1. Independent of Frameworks 2. Testable 3. Indepe