MySQL dump by query

Question

Is it possible to do mysqldump by single SQL query?

I mean to dump the whole database, like phpmyadmin does when you do export to SQL

Answer 1

Try using this query:

mysqldump --databases X --tables Y --where="1 limit 1000000"