Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#1: mysqldump select query

Posted on 2007-06-28 00:06:27 by Monty Loree

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.

Report this message

#2: Re: mysqldump select query

Posted on 2007-06-29 05:32:44 by Shawn Hamzee

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".

Report this message