mysqldump select query

I am trying to do a dump for a 2 gig table...

I would like to dump the tables in portions so that it's a little
easier to work with...

Can somebody suggest a way to do a mysqldump table query

ie.. mysqldump -u user -p database="MYDATABASE" Query="SELECT * FROM
TABLE WHERE State='NV';"

I'm pretty sure this is possible... I have no idea how to do it.

Thanks in advance.

Re: mysqldump select query

Monty Loree wrote:
> I am trying to do a dump for a 2 gig table...
>
> I would like to dump the tables in portions so that it's a little
> easier to work with...
>
> Can somebody suggest a way to do a mysqldump table query
>
> ie.. mysqldump -u user -p database="MYDATABASE" Query="SELECT * FROM
> TABLE WHERE State='NV';"
>
> I'm pretty sure this is possible... I have no idea how to do it.
>
> Thanks in advance.
>

the statement does not look right so i am not as sure as you are;
however, you can run something like this to backup table at a time:
mysqldump -p -u username databasename tablename > tablename.sql

once you run this, it'll ask you for your password, type it in and
voila, you get a text file of a backed up table.

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".