mysql export database command dump only single table code example

Example 1: mysql dump with table query

mysqldump db_name table_name --where="id > 1"

Example 2: mysqldump 1 table only

mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql