mysqldump help:
-w, --where=name Dump only selected records; QUOTES mandatory!
Attention: QUOTES mandatory, or shell will not parse it correctly.
eg:
mysqldump -uroot -pyes test_db tb --no-create-info -w "msg_id = '123456'" > out_records.sql
mysqldump help:
-w, --where=name Dump only selected records; QUOTES mandatory!
Attention: QUOTES mandatory, or shell will not parse it correctly.
eg:
mysqldump -uroot -pyes test_db tb --no-create-info -w "msg_id = '123456'" > out_records.sql