From: Michael Dykman
Date: October 29 2009 5:24pm
Subject: Re: Choose certain columns in mysqldump?
List-Archive: http://lists.mysql.com/mysql/219186
Message-Id: <814b9a820910291024u5372821n29863700722290ad@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

mysqldump is not really a data manipulation tool.. as the name
implies, it is a dumper.

What you are trying to accomlish can be done rather elegantly via the
SELECT .. INTO OUTFILE syntax

                    http://dev.mysql.com/doc/refman/5.1/en/select.html

and then loaded into your new structure via LOAD INFILE

                    http://dev.mysql.com/doc/refman/5.1/en/load-data.html


 - michael dykman


On Thu, Oct 29, 2009 at 1:09 PM, Brian Dunning <brian@stripped> wro=
te:
> Sorry if this is a n00b question, I did read the docs for mysqldump befor=
e
> posting, but couldn't figure it out.
>
> I'm successfully doing a mysqldump, but I want only a few of the columns,
> and want them in a different order. Is this possible without substantiall=
y
> slowing it down? The table has about 5 million records.
>
> Currently I'm doing this:
> mysqldump -uxxxt -pxxx -t -T/var/www/folder db_name table_name
> --fields-enclosed-by=3D\" --fields-terminated-by=3D,
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
.com
>
>



--=20
 - michael dykman
 - mdykman@stripped

"May you live every day of your life."
    Jonathan Swift