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