dump

db dump mysql

MySQL Dump with condition

Solution

mysqldump -u root -p pass my_database my_table --where="id IN (100, 101)" > my_table_dump.sql

 

View