Re: mysqldump on specific columns only?

2008-03-09 Thread Rob Wultsch
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote: I'm trying to dump all the columns of a table but one in a restructuring of my schema. I found this post: http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html which seems to indicate that this isn't

Re: mysqldump on specific columns only?

2008-03-09 Thread Tim McDaniel
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote: Subject: Re: mysqldump on specific columns only? I'm trying to dump all the columns of a table but one in a restructuring of my schema. By dump, I assume you mean output, not delete. I suspect I'm too inexperienced in MySQL

Re: mysqldump on specific columns only?

2008-03-09 Thread Waynn Lue
Thanks for the responses, Inline: On Sun, Mar 9, 2008 at 7:49 PM, Tim McDaniel [EMAIL PROTECTED] wrote: On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote: Subject: Re: mysqldump on specific columns only? I'm trying to dump all the columns of a table but one

Re: mysqldump on specific columns only?

2008-03-09 Thread Rob Wultsch
MySQL does provide LOAD DATA INFILE (http://dev.mysql.com/doc/refman/5.0/en/load-data.html), but I was hoping to do it through mysqldump instead of SELECT INTO because I assumed the performance was faster. If that's not the case, though, I'll go ahead and use SELECT INTO OUTFILE and

mysqldump on specific columns only?

2008-03-08 Thread Waynn Lue
I'm trying to dump all the columns of a table but one in a restructuring of my schema. I found this post: http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html which seems to indicate that this isn't possible, but I was wondering if anyone had any suggestions. My current