I agree, missed it in documentation. Thanks Arjen...

On Wed, May 19, 2010 at 6:08 PM, Arjen Lentz <arjen@openquery.com> wrote:
Hi


On 20/05/2010, at 3:12 AM, Cool Guy wrote:
mysqldump is more like a backup tool and is used to dump the whole table/database rather than select records ...

Not necessarily.
For instance, you can optionally provide a WHERE clause.


Regards,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org