Is there a way to ignore certain fields of a table using mysqldump without creating a view?
+3
A:
Not with mysqldump. You probably want to use SELECT ... INTO OUTFILE instead. See http://dev.mysql.com/doc/refman/5.1/en/select.html
(and then you can use LOAD INFILE to restore it: http://dev.mysql.com/doc/refman/5.1/en/load-data.html)
so that works for dumping tables quickly. But if I have to ignore a list of fields across tables in a database it get's messy. I also want to then pipe the result to a separate server and load it into a mysql db their.
Dan
2010-07-24 20:38:43
i'll give it the check mark since it does correctly answer the question and I hate not giving it out. Thanks!
Dan
2010-07-28 00:54:30