how to dump only data from one table mysqldump code example Example: mysql dump with table query mysqldump db_name table_name --where="id > 1"