Question: So that is the question: 

how to revert to specific commit in history while saving current work to another branch? 

I've tried checking out to another branch and then `git reset --hard commit_hash` but the other branch was reverted too and i don't want this.

Answer: 
That seems to happen because you are using `mysqldump` 5.5 or prior with a MySQL 5.6 database. The `SET OPTION` syntax was removed (see discussion in [this bug report](http://bugs.mysql.com/bug.php?id=66765)), causing this tool to stop working.

You will need to update your version of `mysqldump`. More info about it in [this other bug report](http://bugs.mysql.com/bug.php?id=67507).
Thanks to the answer from javidcf, I found the answer to my question. The solution is to use a command-line mysqldump version that supports MySQL 5.6.