Hi,

> Is there a way to redirect the output of a MySQL statement like SHOW
> VARIABLES to a file?

This is extremely easy. On the command line, simply do the following:

$ mysql -u youruser -p --execute="show variables" > yourfile.txt

For info on various command line arguments (including alternative output
formatting) consult the application's help, by entering:

$ mysql --help

Regards,

Basil Hussain
---------------------------------------
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to