mysql table dump command line code example

Example 1: mysql backup table

mysqldump db_name table_name >  table_backup.sql

Example 2: mysql dump with table query

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

Example 3: mysqldump 1 table only

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