mysql dump a list of query to file and restore to another database
I think if you're going to use a WHERE clause, you need to specify your table in the mysqldump command. You also just need to include the WHERE clause and not the corresponding SELECT - as per follows:

mysqldump -t -u dk2303 -p my_database journal_details  --where="journal_id = 28679"  



journal_details is your table.  
--h 127.0.0.1 is the default anyway so not necessary  
--default-character-set=utf8 (keep this - may be default also?)  
--result-file=/home/dk/dump.sql (you can keep this also, otherwise just use the &gt; redirect operator)   


See here for more details.