OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
mysqldump on specific columns only?

From: Waynn Lue (waynnluegmail.com)
Date: Sun Mar 09 2008 - 00:55:44 CST


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 solution is to do a simple
search and replace, but that won't work for everything. I could
always do regex search/replace, as well, but I'm hoping for something
native to mysqldump, since the files are going to be rather big.

Thanks,
Waynn

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql