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 <[email protected]> wrote:
> Sorry if this is a n00b question, I did read the docs for mysqldump before
> 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 substantially
> 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=\" --fields-terminated-by=,
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[email protected]
>
>
--
- michael dykman
- [email protected]
"May you live every day of your life."
Jonathan Swift
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
