I usually use the --tabs option on mysqldump. However, if a table has a function, procedure, or trigger, the code is not written to a file but rather to standard out. Is this the only way to dump them using the --tabs option? I thought of trying to use the Information Schema database somehow but that would make it a 2 step process.
If redirecting to STDOUT is the only way to do it, are there any plans to change this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com